QlikView Your Business. Troyansky Oleg

Читать онлайн.
Название QlikView Your Business
Автор произведения Troyansky Oleg
Жанр Зарубежная образовательная литература
Серия
Издательство Зарубежная образовательная литература
Год выпуска 0
isbn 9781118949573



Скачать книгу

time, the two fields are aggregated separately, and then one summarized result is subtracted from the other. The end result of the two expressions is virtually identical (there might be subtle differences that have to do with missing values, but you can ignore them at the moment).

      However, the following two expressions will produce completely different results, despite the similarities:

      versus

      The first expression calculates the average margin percent, and it’s accurate – the summarized Cost of Goods Sold (COGS) is subtracted from the summarized Sales Amount, and the result is divided by the summarized Sales Amount. Conversely, the second expression, while valid syntax-wise, is logically incorrect. The margin percent calculation is enclosed in a single aggregation function, therefore it is performed at every detail line, and then the resulting percentages are summarized. Even if you replaced sum() by avg(), the result would be different from the formula above, and most likely be different from the expected result.

      To summarize this brief introduction to chart expressions, let’s emphasize the two points that you’ve just seen:

      ● Chart expressions should always be defined with an aggregation function.

      ● When multiple fields are involved in a calculation, it’s important to determine the order of operations – which calculations need to happen at a detailed level and which calculations need to apply to the aggregated results.

      Chart Dimensions

      If charts always show aggregated data and chart expressions define what aggregation functions should be used, then dimensions describe the level of aggregation for the chart.

      Конец ознакомительного фрагмента.

      Текст предоставлен ООО «ЛитРес».

      Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.

      Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAQCAwMDAgQDAwMEBAQEBQkGBQUFBQsICAYJDQsNDQ0LDAwOEBQRDg8TDwwMEhgSExUWFxcXDhEZGxkWGhQWFxb/2wBDAQQEBAUFBQoGBgoWDwwPFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhb/wAARCAMlAugDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD7+ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAr4w/wCCh3xMvz8TtL8KeH9TuLRvDiC5nmtZjG4uZACBuU5+VMf99mvrnx34gsfCng3U/EmpPttdLtXuJOfvbRkKPcnAHuRX5ceLNavvE3ivUfEGpvvu9TupLmY/7TsTgewzgewryc1rcsFTXX+v69D9C8PspWJxk8XUV4wVl6v/ACV/vR7r8I/2svHnh/yrPxVDD4lslwDJJiK6Uf8AXQDDf8CGfevp34U/Hj4cePFigsdZXT9QkA/0DUcQyZ9FJO1/+Akn2r85rdavW615lLMa9LrdeZ+gZhwDlOY3lCPspvrHb5x2+63qfqtRXhv7Bdl4k