how to calculate values (ecxcel funktion countif)

[#1]

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

[swuehl · Accepted solution]

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

[#3]

Thanks for your help!