topic Re: Pivot table years in QlikView

Pivot table years

Fri, 26 Sep 2014 03:05:43 GMT

Hi ,

I am attaching the app and i need the values as it in mentioned with out hard !coding those values

JonnyPoole — Fri, 26 Sep 2014 03:38:40 GMT

Give this example a try.

1. Simplified the SET ANALYSIS

2. used before() function to grab the values from the TOTAL and DUAL PACK and subtract prior column(Year)

3. Dynamic to number of years (3 in this case but will work dynamically if there were more or less years)

Fri, 26 Sep 2014 03:59:32 GMT

Hi Jonathan thanks for your reply it is working fine but a small concern if we have more data in 2012 also showing some values that should not be

Fri, 26 Sep 2014 04:12:44 GMT

the concern is

if we have 0's are no value in 2012 the values are showing in 2012 column

so how to remove the data if we have 0's are no data

JonnyPoole — Fri, 26 Sep 2014 12:25:24 GMT

I added an IF expression to check if its the first column (first YEAR). If it is, the DIFF calcs will show as blank.

I also updated the presentation tab to render nulls as blank rather than 0's.

Anonymous — Fri, 26 Sep 2014 15:10:06 GMT

see attached.