Discussion Board for collaboration on QlikView Layout & Visualizations.
I have 10 variables with score and 1 variable string.
I want to make chart like showen in picture.
I don't want to use 30 expressions.
Do you have any ideas how to do it?
Please find my attached file.
Go to Solution.
Try using a CROSSTABLE LOAD of your input data:
CrossTable (Dim1, Score,1) LOAD * resident Test$;
drop table Test$;
Then your chart is just a bar chart with dimensions Dim1, A and an expression like avg(Score). See also attached.
Transform your data with the crosstable function
(biff, embedded labels);
You can then use Key as the first dimension and A as the second dimension and avg(Value) as expression. See attached example
Thank you for your help.
I didn't work with crosstab. I have also other variables in my file. It makes crosstab with other variables.
How can I fix it?
Thanks guys. Your both issues are right.
I found out how to do it.