Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share a sample what you tried and having issues with?