Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help with what a problem I think Set Analysis can solve.
I'm trying to create a table with the field WeekNo to be used as a selection box.
I am then excluding Max(WeekNo) from the table.
The issue is that every WeekNo I select becomes the Max WeekNo when I make the selection! So my table is blank!
How can I create Max(WeekNo) where it is set in the data? And not affected by my Selections?
Try:
Max({1}WeekNo)
Spot on - Cheers
Glad Arthur got you hooked up, here is a Design Blog post that may be helpful in the future related to Set Analysis, be sure to check it out, I think you will find it very helpful.
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
If you want to search that area of Community further for other posts, there are 700+, here is the link to use:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett