topic Re: count with multiple values in Qlik Automate

count with multiple values

Jkoering — Fri, 21 Jun 2024 05:57:04 GMT

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",...

AndyC — Fri, 21 Jun 2024 07:37:41 GMT

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?