Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Probably over complicating this but I have an if statement as such :
if ( Sales >0 and Profit=0), Bucket_1,
if ( Sales=0 and Profit=1), Bucket2,
Bucket3 ) as My_Field
The issue is that Bucket 3 will the show whatever is not included in bucket 1 and bucket2. However instead I want Bucket 3 to show everything ie a total of everything before it is bucketed rather than what's left over.
You probably want a separate field for the "Everything" bucket.
My_Field can't be both a subset and a superset all in one.
What about:
if (Sales > 0 and Profit = 0,
Bucket_1,
if (Sales = 0 and Profit = 1,
Bucket_2,
Optional_Leftovers_Bucket
)
) as My_Category_Field,
Bucket_3 as My_Totals_Field,
...Your buckets are calculations, not just labels, yes?
Did Joanna's post help you get things working as you wished? If so, please be sure to give her credit by clicking the Accept as Solution button on her post. If you used a different solution, you can post that as well and mark it such that others can learn from things.
Lastly, if you are still looking for things, here is a Design Blog post that might help:
https://community.qlik.com/t5/Qlik-Design-Blog/Buckets/ba-p/1463216
Regards,
Brett