Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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)
Highlighted
Contributor II
Contributor II

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);

Highlighted

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