Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
acepeda71
Contributor II
Contributor II

Pivot Table calculated field - expression syntax request

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.

Screen Shot 2018-01-13 at 19.37.35.png

Thanks in advance for your help.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

two measure should be

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Anil_Babu_Samineni

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
acepeda71
Contributor II
Contributor II
Author

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

two measure should be

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)