topic Re: Pivot Table calculated field - expression syntax request in QlikView

Pivot Table calculated field - expression syntax request

Anonymous — Sat, 13 Jan 2018 22:46:48 GMT

Hello,

May i have some help on this.

growth

I have the following data set (blue) and i need to create a Pivot Table report as shown in the bottom Table (green).

I have seen a lot of examples but I have not yet found the syntax I need to build the growth expression.

Thanks in advance for your help.

Anil_Babu_Samineni — Sun, 14 Jan 2018 02:45:42 GMT

Please post data in excel/text format instead image? But, I don't think in your example there is anything tough. Try

Dimension is Month

And, Expressions are

Sellin - Sum({<Status = {"Sellin"}>} Measure)

Sellin - Sum({<Status = {"Sellout"}>} Measure)

Anonymous — Sun, 14 Jan 2018 03:45:10 GMT

Hello Anil, thanks for your answer.

Attached the excel table.

I tried your code in a Pivot Table as shown in the attached screenshots but data is not displayed.

this is the script

LOAD Status,

Product,

[Stock Number],

Month,

Sales,

Units

FROM

(ooxml, embedded labels, table is Sheet1);

Anil_Babu_Samineni — Sun, 14 Jan 2018 03:53:35 GMT

two measure should be

Sum({<Status = {"Sellin"}>} Sales)

Sum({<Status = {"Sellout"}>} Sales)