Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everybody,
I'm confronted with a problem.
perhaps you can although help me out.
DATA
Titel | Q1 | Q2 | Q3 |
---|---|---|---|
a | x | v | o |
b | v | v | x |
c | x | x | v |
d | o | o | x |
How can I calculate the following table and visible it in 3 (staple) graphs for x, v, o
In Excel I would use countif.
x | v | o | |
---|---|---|---|
Q1 | 2 | 1 | 1 |
Q2 | 1 | 2 | 1 |
Q3 | 2 | 1 | 1 |
Thanks for your help,
Florian
Florian,
you can do it like this:
First do a Crosstable load of your DATA:
CrossTable(Q, Data)
LOAD Titel,
Q1,
Q2,
Q3
FROM
[http://community.qlik.com/thread/39905?tstart=0]
(html, codepage is 1252, embedded labels, table is @1);
then create a pivot table with dimension Q and Data and as expression use
=count(Titel)
Hope this helps,
Stefan
Florian,
you can do it like this:
First do a Crosstable load of your DATA:
CrossTable(Q, Data)
LOAD Titel,
Q1,
Q2,
Q3
FROM
[http://community.qlik.com/thread/39905?tstart=0]
(html, codepage is 1252, embedded labels, table is @1);
then create a pivot table with dimension Q and Data and as expression use
=count(Titel)
Hope this helps,
Stefan
Thanks for your help!