topic Re: Help with set analys in QlikView

Help with set analys

Wed, 21 Nov 2012 09:04:42 GMT

Hello!

I have a variable that we can call "variable" which has several different variables mounths. But I would just like to read Varable A values for January-December. How do I do it in the best way?

For example

Variable	Jan	Feb	Mar	Apr
A	1	1	1	1
B	2	2	2	2
C	3	3	3	3
D	4	4	4	4
E	5	5	5	5
F	6	6	6	6

Re: Help with set analys

Wed, 21 Nov 2012 09:20:25 GMT

Hai,

I unnderstood u r requirement

pls shere any sample file

Thanks&Regards,

chandu

Re: Help with set analys

Wed, 21 Nov 2012 14:54:37 GMT

Hello!

I've created a file where I have removed the variable names and framed letters instead, hope that you understand the material. What I therefore would like to show is therefore, digits for only var1 A - Var2 A, row 3, for example,

And I think I have to load the data set in this way because I have a lot of other varitabler I've taken away from this, and I want to be able to roll lists on var1 and Var2

Re: Help with set analys

fosuzuki — Thu, 22 Nov 2012 16:49:58 GMT

Is this what you want to do?

CrossTable(Month, Value, 2)

LOAD Var1,

Var2,

Januari,

Februari,

Mars,

April,

Maj,

Juni,

Juli,

Augusti,

September,

Oktober,

November,

December

FROM

Examlpe.xlsx

(ooxml, embedded labels, table is Blad1);

Re: Help with set analys

Fri, 23 Nov 2012 07:59:48 GMT

Hello!

I want to make a line graph with only ensast values of a variable in var1 and Var2. Type number three in the Excel file, A and A.

Re: Help with set analys

fosuzuki — Fri, 23 Nov 2012 10:06:14 GMT

What about this:

CrossTable(Month, Value, 2)

LOAD Var1,

Var2,

Januari,

Februari,

Mars,

April,

Maj,

Juni,

Juli,

Augusti,

September,

Oktober,

November,

December

FROM

Examlpe.xlsx

(ooxml, embedded labels, table is Blad1)

Where Var1 = 'A' and Var2 = 'A';