Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Missing valuelist dimension in table

Hi

Please tell me how to show missing values valuelist dimension  in qlikview pivot table

In My case created valuelist for 3 dimensions and for each dimension finding count based on marks.

Valulist('Denied,''Promoted','Passed')

In below  expression returned  for denied dimension

which is returning null ,since no data availabel to meet conditions

Count({<marks={"<=36"}>}studentid)

For above case only 2 value list columns (passed and ptomoted)showing in table and the null returned dimension: denied missing.

Please tell how show missing dimension  in this case

Message was edited by: Kalyan DEVARA

1 Reply
vishsaggi
Champion III
Champion III

Can you share a sample what you tried and having issues with?