topic Re: Select top 5 and make chart in QlikView

Select top 5 and make chart

Anonymous — Mon, 28 Jan 2013 16:05:26 GMT

Hi,

I have 11 variables, which consist 0 or 1. Sometimes in 1 row they have more than one answer "1".

Var0	Var1	Var2	Var3	Var4	Var5	Var6	Var7	Var8	Var9	Var10	Var11
A
B
A	1	0	0	0	1	0	0	0	0	0	0
B	1	0	0	0	0	0	0	0	0	0	0
A
A	0	0	0	0	1	0	0	0	0	0	0
B
B	0	1	0	0	1	0	0	0	0	0	0
A
A
B
A	1	0	0	0	1	0	0	0	0	0	0
A	0	0	1	0	0	0	0	0	0	0	0
C	0	0	0	0	1	0	0	0	0	0	0
A
A
A	1	0	0	0	0	0	0	0	0	1	0
A	1	0	0	0	0	0	0	0	0	0	0
A
C	0	0	0	0	1	0	0	0	0	0	0
B	0	0	0	0	0	0	1	0	0	0	0
A	0	0	0	0	0	1	0	0	0	1	0
A	0	0	0	0	0	0	1	0	0	0	0
B
B	0	0	0	0	0	1	0	0	0	0	0
C
C	1	0	0	0	0	0	0	0	0	0	0
B	0	0	0	0	1	0	0	0	0	0	0
B	0	0	1	0	1	0	0	0	0	0	0
A
A	1	0	0	1	0	0	1	0	0	0	0
D
B	1	0	0	0	0	0	0	0	0	0	0
A	0	0	0	0	0	0	0	0	0	0	0
A
D
C	1	0	0	0	0	0	0	0	0	0	0
C
A
A	0	0	1	0	0	0	0	0	0	0	0
C
D
A
D
A
C
A
A
C	1	0	0	0	1	0	0	0	0	0	0
A
A
B	1	1	0	0	0	0	0	0	0	0	0
A	0	0	0	0	0	0	0	0	0	0	0
A	1	1	0	0	0	0	0	0	0	0	0
E	1	0	0	0	0	0	0	0	0	0	0
B	1	0	0	0	0	0	0	0	0	0	0
D	0	1	0	0	1	0	0	0	0	0	0
B	0	0	0	0	1	0	0	0	0	0	0
B
B
B	0	0	0	0	1	0	0	0	0	0	0
B	1	0	0	0	1	0	0	0	0	0	0
B
A	1	0	0	0	0	0	0	0	0	0	0
B	0	0	1	0	1	1	0	0	0	0	0
B	0	0	0	0	0	0	0	0	0	0	0
B	0	0	0	0	1	0	0	0	0	0	0
B	0	1	0	0	1	0	0	0	0	0	0
B	1	1	0	1	0	0	0	0	0	0	0
TOTAL	17	6	4	2	16	3	3	0	0	2	0

I'd like to create multiple response set. (Insted of 11 variables create 1 variable, who choose 1).

And make chart dim Var0; expression count( NEW Var)

Regards,

Re: Select top 5 and make chart

swuehl — Mon, 28 Jan 2013 16:42:42 GMT

Vladimir,

I think you should be able to use the CROSSTABLE LOAD prefix also for this request (like in your previous Help with idea post).

Regards,

Stefan

Re: Select top 5 and make chart

Anonymous — Mon, 28 Jan 2013 19:57:25 GMT

Hi Stefan,

I load the second crosstab with keyID.

Not_Completing_Transaction:

CrossTable (Key, AAA,2) LOAD ID, Var0,

Var1, Var2, Var3, Var4, Var5, Var6, Var7, Var8, Var9, Var10, Var11;

SQL SELECT ID,Var0,

Var1, Var2, Var3, Var4, Var5, Var6, Var7, Var8, Var9, Var10, Var11

FROM "qqq".dbo."myfile";

In chart

Dim. Key

Expression: Count({<Var0=>} AAA) ---shows my total count

but I need to in %

I tried

Count({<Var0=>} AAA) /

Count({<Var0=>} TOTAL <Key> AAA)

how to calculated in %?

Thanks,

Re: Select top 5 and make chart

swuehl — Tue, 29 Jan 2013 09:44:46 GMT

In chart
Dim. Key
Expression: Count({<Var0=>} AAA) ---shows my total count

I am not sure what you mean with total count, it should be grouped by your dimension Key (different VarX).

I tried
Count({<Var0=>} AAA) /
Count({<Var0=>} TOTAL <Key> AAA)
how to calculated in %?
Thanks,

If your single dimension is Key, this should return 1 for all lines, correct?

Try something like:

=count( AAA) / count( TOTAL AAA)

(add set expression if needed), and change format in number tab to percentage.

Regards,

Stefan

Re: Select top 5 and make chart

Anonymous — Tue, 29 Jan 2013 20:52:06 GMT

Hello Stefan,

Please see my Test file.

I made crosstab.

In chart I have the same count for all tags. (it shows my Base count, not individual count for each tags).

i did something wrong.

Regards,

Re: Select top 5 and make chart

swuehl — Tue, 29 Jan 2013 21:07:14 GMT

Seems ok to me.

Maybe you want to count only AAA = 1?

=Count({<[qID_6613_Autofill Hotel or Airline]=, AAA = {1}>} AAA)

=Count({<AAA={1}>} AAA)

Re: Select top 5 and make chart

Anonymous — Tue, 29 Jan 2013 21:31:44 GMT

Thanks for your help.

You're awesome