Discussion board where members can get started with QlikView.
I have a requirement to create a Heat Map like below where one dimension having value : A,B,C and other dimension : 1,2,3 and 4.
Based on some calculation, I got the values as 2,3 and 4 but there is no value for 1 (see image 1).
So, I want to display 1 also here, with value 0 like in Image 2.
PS: On un-checking "Suppress When value is NULL", it is showing ' - ' in dim1 and dim2 both.
Go to Solution.
Thanks for the response. But it didn't worked.
Instead I did inline load as below :
LOAD * INLINE [
Mid(Dimension,1,1) as DIM2,
Mid(Dimension,2,1) as DIM1
DROP Table Dimension;
And this worked for me.
You may need to play with these parameters (see screenshots) :