Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jkoering
Contributor
Contributor

count with multiple values

Hello I would like to count how often several values occur in total.

e.g. Count value 1 + value 2 and give me the total.

I work with Qlik sense

Thank you

with one value I can do it.

count(distinct{<rd_transportziel = {"*Vivantes*"}>}bfw_einsatz_id_anonymisiert

the other arguments are "Urban", "AVK",...

Labels (1)
1 Reply
AndyC
Contributor III
Contributor III

Do you mean that, if I load the following data

LOAD * INLINE [
F1, F2
E, England
E, England
E, England
W, Wales
S, Scotland
S, Scotland
N, Northern Ireland
M, Isle of Man
L, Channel Islands
];

And you want to count 'England' and 'Scotland' the answer would be 5 or 2?