Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Help on Pivot table

Hi Friends ,

i need one table like below ,

req.jpg

which not effect year selection .

6 Replies
Anonymous
Not applicable

Use set analysis in your expression to ignore selections in year

Something like

sum({<Year=>}Values

agni_gold
Specialist III
Specialist III
Author

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

Sergey_Shuklin
Specialist
Specialist

Hello, Agnivesh!

Please, look at the attachement:

ytd.png

agni_gold
Specialist III
Specialist III
Author

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

agni_gold
Specialist III
Specialist III
Author

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

agni_gold
Specialist III
Specialist III
Author

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

How i will handle this ?