Discussion Board for collaboration on QlikView Scripting.
i need help to achieve following table (vertical:A,horizontal,Values: count of S appear) :
with following data:
LOAD * INLINE [
Actually i only achieve this:
Horizontal 1 ... 5 are Expressions like if(S=1,COUNT(S)) ... if(S=5,COUNT(S))
I dont want to display the S Dimension, and want the counted results of S for A, so only one row and not broke up over all S possibilities.
Go to Solution.
1-. Use Pivot Chart.
2-. Create 2 dimensions: A and S
3-. Label Dimejnsion S is a space
4-. Create one Expresion: Count(S)
In presentation Tab put Null Values to 0 or empty.
Maybe like this.
Label for S is a space!
could you please explain your solution as i can not open your file, thanks!
First picture was wrong,
should look like this:
try like this
LOAD *,S as S1 INLINE [
drag the S1 horizontally
Please see the attached
my problem was that I did not know how, that we can display a dimension also horizontal.
Thanks for help!