topic Create buckets conditionally based in dimension in QlikView

Create buckets conditionally based in dimension

selvakumara — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I am using the below expression.

=if(Aggr( Count( client) , client)<=1, '1 time Visit'

,if(Aggr( Count( client) , client)<=2, '2 time Visit'

,if(Aggr( Count( client) , client)<=3, '3 time Visit'

,'More than 3 Visit'

)))

But it always give the 1time visit also not calculating correctly.

Please help me to get all the 3 buckets also looking for alternative solutions.

Thanks in advance

Thanks.

Re: Create buckets conditionally based in dimension

QlikNoviceNo1 — Fri, 05 Oct 2018 15:28:33 GMT

Hi Selva,

Is client the only dimension in the chart?

Could you share the chart/qvw?

Thanks.

Re: Create buckets conditionally based in dimension

QlikNoviceNo1 — Fri, 05 Oct 2018 15:40:40 GMT

Re: Create buckets conditionally based in dimension

selvakumara — Fri, 05 Oct 2018 15:46:48 GMT

Yes. Client only in the dimension.

Measures - Count (Client)

Re: Create buckets conditionally based in dimension

vamsee — Fri, 05 Oct 2018 16:36:06 GMT

Try

=Aggr(

IF(

Count(Client)<=1, '1 Time Visit',

IF(Count(Client)=2, '2 Time Visit',

IF(Count(Client)=3, '3 Time Visit',

IF(Count(Client)>3, 'More Than 3 Time Visit', ))))

,Client)

Re: Create buckets conditionally based in dimension

vamsee — Fri, 05 Oct 2018 16:38:20 GMT

Your measure has to be Count( Distinct Client)

Re: Create buckets conditionally based in dimension

MarcoWedel — Sat, 06 Oct 2018 19:42:02 GMT

Hi,

another expression for your calculated dimension might be:

=Aggr(If(Count(client)<=3,Count(client)&' time Visit','More than 3 Visit'),client)

hope this helps

regards

Marco

Re: Create buckets conditionally based in dimension

selvakumara — Mon, 08 Oct 2018 07:22:28 GMT

Still, I'm facing same issue. It is showing the 1 time visit rather than all the visit.

I don't know what I am missing.

Thanks for your response.

Re: Create buckets conditionally based in dimension

selvakumara — Mon, 08 Oct 2018 09:38:51 GMT

Didn't solve my issue @ Marco Wedel

Re: Create buckets conditionally based in dimension

selvakumara — Mon, 08 Oct 2018 09:41:03 GMT

In the 137309 id falling under 1 and 3 time visit. But it's not coming correctly. That's my problem

Thanks everyone for your response.

Re: Create buckets conditionally based in dimension

vamsee — Mon, 08 Oct 2018 14:12:18 GMT

Hi,

Do you have any other dimension in your chart?

The above suggestion is working for me.

Re: Create buckets conditionally based in dimension

selvakumara — Mon, 08 Oct 2018 14:27:45 GMT

Thanks for your solution vamsee duggirala. It's working for me. I'm using the below expression.

Aggr(

IF(Count({1<[Source]={'xxx'}>} Client & [Name])<=1, '1 Time Visit',

IF(Count({1<[Source]={'xxx'}>} Client & [Name])<=2, '2 Time Visit',

IF(Count({1<[Source]={'xxx'}>} Client & [Name])<=3, '3 Time Visit',

)))

,Client)

But, I'm facing another issue. I have a donut it display all the three categories. But If selected any category example '1 time visit'. it will display client on the filter panel.

I have tried to some solutions. it's not working

Kindly advice

Thank,

Selva

Re: Create buckets conditionally based in dimension

vamsee — Mon, 08 Oct 2018 14:44:19 GMT

For that, you might have to create this column in the script.

Re: Create buckets conditionally based in dimension

MarcoWedel — Fri, 12 Oct 2018 20:40:00 GMT

Interesting, it seems to work for me.

Maybe you can describe your issue well enough so it can be solved?

hope this helps

regards

Marco

Re: Create buckets conditionally based in dimension

MarcoWedel — Fri, 12 Oct 2018 20:41:48 GMT

So a client selection defines a non working solution per your requirement?