topic Re: Help on Pivot table in QlikView

Help on Pivot table

agni_gold — Thu, 11 May 2017 17:16:07 GMT

Hi Friends ,

i need one table like below ,

which not effect year selection .

Re: Help on Pivot table

Anonymous — Thu, 11 May 2017 17:30:21 GMT

Use set analysis in your expression to ignore selections in year

Something like

sum({<Year=>}Values

Re: Help on Pivot table

agni_gold — Thu, 11 May 2017 17:36:23 GMT

but for current year 2017 , 3 expression should come and for remaining year only one expression i.e FY should come

Re: Help on Pivot table

Sergey_Shuklin — Thu, 11 May 2017 17:46:29 GMT

Hello, Agnivesh!

Please, look at the attachement:

Re: Help on Pivot table

agni_gold — Thu, 11 May 2017 17:50:07 GMT

thanks for your help , but as i mentioned in my screenshot KPI should come same like that current year is 2017 then 3 columns YTD YTG and FY come below 2017 and for further years only FY expression should come below

Re: Help on Pivot table

agni_gold — Thu, 11 May 2017 17:51:57 GMT

YTD should not be dimension , YTD YTG and FY should me expression

Re: Help on Pivot table

agni_gold — Mon, 15 May 2017 14:01:14 GMT

but in some case my existing value got zero , then it will also get suppressed.

How i will handle this ?