Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

how to write an expression in pivot table without change its values by selecting any selectors

Hi all 

i have a pivot table and year selector,if i select the year selector then in pivot table outstand fields are changing to zero, i had used set analysis but does not  work,my requirement is to show static values for that field,can anyone know how to do this?

 

 

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Change all the measures that you use in the pivot table. Change for example sum(Amount) to sum({1} Amount). The {1} part will make the measure ignore any and all selections the user makes.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Change all the measures that you use in the pivot table. Change for example sum(Amount) to sum({1} Amount). The {1} part will make the measure ignore any and all selections the user makes.


talk is cheap, supply exceeds demand

View solution in original post