Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hai,
I unnderstood u r requirement
pls shere any sample file
Thanks&Regards,
chandu
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
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);
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.
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';