Select top 5 and make chart

[Anonymous]

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,

[swuehl]

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

[Anonymous]

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,

[swuehl]

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

[Anonymous]

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,

[swuehl · Accepted solution]

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)

[Anonymous]

Thanks for your help.

You're awesome