Normal Expression to Set Expression

baliyan_vinay — Sat, 16 Nov 2024 00:53:36 GMT

Hi Community,

I am struggling to transform a normal expression into set expression. I would require set here because I want to have just one filter work on the chart and other not.

This is my normal expression.

Count(Distinct If(Aggr(Max(LAB_STAT),Link_Key)>=8000 and Aggr(Max(LAB_STAT),Link_Key) < 8050 and Aggr(MaxString(HOLD_FLG),Link_Key) <> 'Y' and Aggr(Max(CANCEL_FLG),Link_Key) <> 'Y', Link_Key))

I would create an alternate state for the chart and would add the one filter which should work like this

Month_Name= $::Month_Name

I am very new to set analysis, your help can really solve this for me.

Thanks

Re: Normal Expression to Set Expression

Brett_Bleess — Wed, 29 Apr 2020 14:31:20 GMT

Have a look at the following Design Blog post, believe that should help, there are two links at the bottom of the post to other related blog posts too, just FYI, so hopefully these will get you what you need to get things sorted.

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

topic Normal Expression to Set Expression in QlikView

Normal Expression to Set Expression

Re: Normal Expression to Set Expression