Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to calculate values (ecxcel funktion countif)

hi everybody,

I'm confronted with a problem.

perhaps you can although help me out.

DATA

TitelQ1Q2Q3
axvo
bvvx
cxxv
doox

How can I calculate the following table and visible it in 3 (staple) graphs for x, v, o

In Excel I would use countif.

xvo
Q1211
Q2121
Q3211

Thanks for your help,

Florian

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

Not applicable
Author

Thanks for your help!