Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ajayvermaida
Partner - Creator
Partner - Creator

How can I show missing values in pivot table ?

Hi All

in one of the requirement I have to fix the dimension in pivot table like if someone select filter the dimension then all the dimension still there only expression filter out for example 

suppose we I have 10 dimension and 1 expression in pivot and if someone select 2 dimension I then expression shows the amount for that selected dimension and rest eight dimensions values show nothing but not disappears .  

currently what happened if i select some dimension Qlik filter out on the basis of selection and rest all dimension will disappear .

please help me how I can achieve this requirement 

Thanks in advance

 

10 Replies
anushree1
Specialist II
Specialist II

Sample application and the desired output will help us understand and provide suggestions to your query , so request you to provide the same