Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all,
could anyone help me to solve a Set Analysis issue?
I'm using Set Analysis in Qlik Sense. I've to consider a subset of data among two selected values: "soglia_punti_min" and "soglia_punti_max".
Between a range (selected by users through two different filters) I have to count the number of customers that has more than the start-value ("soglia_punti_min") and less than the end-value (soglia_punti_max).
Due to a problem with the customers data (wrong codes, double customers...) I need to count CliDescr even though I've to summarize points using CliCode.
This is my expression that works well considering ONLY the start-value of the range:
count(
{$ <CliCode =
{"=sum(CliP_PuntiScontrino) >= [soglia_punti_min]"} >}
CliDescr)
--
I've tried to implement this:
count(
{$ <CliCode =
{"=sum(CliP_PuntiScontrino) >= [soglia_punti_min] <=[soglia_punti_max]"} >}
CliDescr)
..but it doesn't work.
Thanks a lot for your suggestions.
Alessandro
Perhaps like this:
count(
{$ <CliCode =
{"=sum(CliP_PuntiScontrino) >= [soglia_punti_min] AND sum(CliP_PuntiScontrino) <=[soglia_punti_max]"} >}
CliDescr)
Perhaps like this:
count(
{$ <CliCode =
{"=sum(CliP_PuntiScontrino) >= [soglia_punti_min] AND sum(CliP_PuntiScontrino) <=[soglia_punti_max]"} >}
CliDescr)
Hi Gysbert,
it works correctly, thanks a lot.
I don't understand because I've tried also this, but evidently I omitted something in my syntax