Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Each ID to fall in one of 4 buckets

Hi,

I want each ID to fall in one bucket

ID,GROUP,CODE

1,BMW,YES

1,BMW,YES

1,VW,YES

2,FORD,YES 

2,BMW,YES

2,VW,YES

3,BMW,NO

3,VW,

4,FORD,YES 

4,BMW 

4,VW,YES 

 

Group 1

If group = single BMW and code = null = ID4

Group 2

Single BMW and no = ID3

Group 3

VW and more than 1 BMW and yes = ID1

Group 4

VW and single bmw and yes = ID4

 

I know its a lot to ask, I just cant get it to work and some one might enjoy a challenge.

 

Thanks 

 

 

 

3 Replies
abhijitnalekar
Specialist
Specialist

Hi @D19PAL ,

can you please elaborate on what exactly constitutes an error, best with some more examples with grouping. 

Regards,
Abhijit
keep Qliking...
D19PAL
Creator II
Creator II
Author

It's harder to explain to do.

Will the if statements work as four separate or will it have to be a nested if statement?

I've tried separate, first two work, I'm hoping the IDs that dont fit in the first two can stay there, I only want to count thr condition is true.

I was hoping the ones that don't fit in the first two will fill options 3 and 4 but I'm not getting anything

 They are separate if statements, dont they do row by row?

 

 

abhijitnalekar
Specialist
Specialist

Can you share your expression

Regards,
Abhijit
keep Qliking...