topic Re: Help with simple Set Analysis in QlikView

Help with simple Set Analysis

DSTaylor — Sat, 16 Nov 2024 01:20:07 GMT

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?

Re: Help with simple Set Analysis

Arthur_Fong — Fri, 07 Feb 2020 02:46:17 GMT

Try:

Max({1}WeekNo)

Re: Help with simple Set Analysis

DSTaylor — Wed, 12 Feb 2020 12:15:06 GMT

Spot on - Cheers

Re: Help with simple Set Analysis

Brett_Bleess — Wed, 04 Mar 2020 22:20:48 GMT

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