topic Help with Set analysis in QlikView

Help with Set analysis

naveen341 — Sat, 16 Nov 2024 02:21:14 GMT

HI Team
I Have a table with records
Claim No Date Value
1 09/28/2019 $235
2 09/28/2019 $58
3 09/29/2019 $201
4 09/27/2019 $220
5 09/27/2019 $100

I Create two iland tables
min Max
0+ 0+
100+ 100+
200+ 200+

I am thinking of storing min and max selection value in a varaible from island table

When a user select min and max range from a list box i want my set analysis to calculate sum of the value
Can you please help me with set analysis for this

Thanks in Advance

@rwunderlich @sunny_talwar

@marcus_sommer,@Oleg_Troyansky , @sunny_talwar,@rubenmarin ,

Re: Help with Set analysis

naveen341 — Mon, 30 Sep 2019 17:15:34 GMT

Hello Experts

Any help on this is appreciated

Re: Help with Set analysis

naveen341 — Tue, 01 Oct 2019 15:26:00 GMT

@sunny_talwar Can you please help with this

Re: Help with Set analysis

rubenmarin — Tue, 01 Oct 2019 19:17:07 GMT

Wow, I think it's the first time I see so many people tagged in the initial post of a thread.

I'm not sure if I understood the requirements, maybe with:

Sum({<Value={">=$(=Min(min))<=$(=Max(Max))"}>} Value)

Re: Help with Set analysis

naveen341 — Wed, 02 Oct 2019 21:04:31 GMT

Hi @rubenmarin

Thank you for your Respone.

Min and max are my inline tables.

please find the attached screen shot. when I select 100+ to 200+ then I expect claim numbers 1,3,4

please help me with set analysis,

thank you

Re: Help with Set analysis

rubenmarin — Thu, 03 Oct 2019 06:31:37 GMT

So your max is another min? you want values higher than max?

Sum({<Value={">=$(=Max(max))"}>} Value)

Re: Help with Set analysis

naveen341 — Thu, 03 Oct 2019 13:28:00 GMT

NO It is kind of range selection.

When i select min =100+ and max=200+.

i expect the vales ranging from 101 to 300

pfa i am expecting the highlighted values in yellow

Re: Help with Set analysis

rubenmarin — Thu, 03 Oct 2019 13:31:44 GMT

Maybe with:

Sum({<Value={">$(=Min(min))"}>} Value)

In any case it's based on use the appropiate expression between the double quotes (I set it in bold). $(=something) will calculate the value and return it, you can adapt some of the expressions I posted to your needs.

Re: Help with Set analysis

naveen341 — Thu, 03 Oct 2019 14:27:18 GMT

Hi @rubenmarin @rubenmarin

I Think you are not getting the requirement correctly.User can select any range like 100+ to 500+ then it should pick up the values form 101 to 600.then i expect all the records ranging from 101 to 600. min and max can be any selection.

Please find attached screen shot i expect the records highlighted in yellow

Re: Help with Set analysis

rubenmarin — Thu, 03 Oct 2019 18:38:52 GMT

It will be better if you upload a sample instead of the snapshot.

So values should be higher than min and lower than the next value of the selected max?

Maybe with a variable that stores that max value

variable varMax with value =FirstSortedValue({1<max={">$(=min(max))"}>} max, max)

and the expression can be:

=Sum({<value={">$(=Min(min))<=$(varMax)"}>} value)

Re: Help with Set analysis

Brett_Bleess — Tue, 08 Oct 2019 18:24:32 GMT

Naveen, here is a Design Blog URL on Set Analysis, and there are quite a few others as well:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Some of the others are in the post above, but here is the base Design Blog URL, so you can search yourself for things, I suspect these may help you sort things out on your own potentially.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett