Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
selvakumara
Creator
Creator

Create buckets conditionally based in dimension

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.

14 Replies
vamsee
Specialist
Specialist

Hi,

Do you have any other dimension in your chart?

The above suggestion is working for me.

selvakumara
Creator
Creator
Author

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



vamsee
Specialist
Specialist

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

MarcoWedel

Interesting, it seems to work for me.

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

QlikCommunity_Thread_316036_Pic1.JPG

QlikCommunity_Thread_316036_Pic2.JPG

hope this helps

regards

Marco

MarcoWedel

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