I did posted a question on this few days back and I got few responses.But none of them are working the way I want it. So I thought let me post it once gain to see if some one can resolve this.
I have a pivot chart with calculated dimension. The calculated dimension creates three columns like Low, Medium and High. If I have the data for all the three columns then everything is fine, But if I have values for only one column then it doesn't display the other two columns with zeros.
Tried below:
"Show All Values" option is greyed out because it is Calculated dimension, so this will not work.
un checking "Suppress Zero Values" will not work.
I think there should be some easy way to do this but I am not able to find it. Can some one please let me know if this can be done in Qlikview?
I am attaching the sample Qlikview dashboard and the output that is required.
Thanks
