Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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?