Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with set analys

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

VariableJanFebMarApr
A1111
B2222
C3333
D4444
E5555
F6666
5 Replies
Not applicable
Author

Hai,

I unnderstood u r requirement

pls shere any sample file

Thanks&Regards,

chandu

Not applicable
Author

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

fosuzuki
Partner
Partner

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);

Not applicable
Author

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.

fosuzuki
Partner
Partner

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';