Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Set Analysis - problem with data between a range

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

1 Solution

Accepted Solutions

Re: Set Analysis - problem with data between a range

Perhaps like this:

count(

        {$ <CliCode =

  

        {"=sum(CliP_PuntiScontrino) >= [soglia_punti_min] AND sum(CliP_PuntiScontrino) <=[soglia_punti_max]"} >}

          

          CliDescr)


talk is cheap, supply exceeds demand
2 Replies

Re: Set Analysis - problem with data between a range

Perhaps like this:

count(

        {$ <CliCode =

  

        {"=sum(CliP_PuntiScontrino) >= [soglia_punti_min] AND sum(CliP_PuntiScontrino) <=[soglia_punti_max]"} >}

          

          CliDescr)


talk is cheap, supply exceeds demand
Not applicable

Re: Set Analysis - problem with data between a range

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