Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vovan4ik
Valued Contributor II

Help with idea

Hello,

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?Capture.JPG

Please find my attached file.

1 Solution

Accepted Solutions
MVP
MVP

Re: Help with idea

Try using a CROSSTABLE LOAD of your input data:

RESULT:

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.

Regards,

Stefan

5 Replies
MVP
MVP

Re: Help with idea

Try using a CROSSTABLE LOAD of your input data:

RESULT:

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.

Regards,

Stefan

Re: Help with idea

Transform your data with the crosstable function

crosstable(Key,Value,1)

LOAD A,

     a,

     b,

     c,

     d,

     e,

     f,

     g,

     h,

     i,

     j

FROM

C:\Users\Desktop\Test.xls

(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


talk is cheap, supply exceeds demand
vovan4ik
Valued Contributor II

Re: Help with idea

Hi Stefan,

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?

Regards,

Vladimir

vovan4ik
Valued Contributor II

Re: Help with idea

Hi Gysbert,

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?

Regards,

Vladimir

vovan4ik
Valued Contributor II

Re: Help with idea

Thanks guys. Your both issues are right.

I found out how to do it.

Community Browser