Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?