topic Re: Help with idea in QlikView

Help with idea

Anonymous — Thu, 24 Jan 2013 16:47:18 GMT

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?

Please find my attached file.

swuehl — Thu, 24 Jan 2013 17:03:35 GMT

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

Gysbert_Wassenaar — Thu, 24 Jan 2013 17:09:39 GMT

Transform your data with the crosstable function

crosstable(Key,Value,1)

LOAD A,

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

Anonymous — Fri, 25 Jan 2013 16:13:19 GMT

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

Anonymous — Fri, 25 Jan 2013 16:13:53 GMT

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

Anonymous — Fri, 25 Jan 2013 16:57:59 GMT

Thanks guys. Your both issues are right.

I found out how to do it.