Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vamsee
Valued Contributor

Re: Create buckets conditionally based in dimension

Hi,

Do you have any other dimension in your chart?

The above suggestion is working for me.

Highlighted
selvakumara
New Contributor III

Re: Create buckets conditionally based in dimension

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
Valued Contributor

Re: Create buckets conditionally based in dimension

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

Re: Create buckets conditionally based in dimension

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

Re: Create buckets conditionally based in dimension

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