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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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