topic Re: SetAnalysis Expr checking in Qliksense in QlikView

SetAnalysis Expr checking in Qliksense

Fri, 22 Apr 2016 08:05:26 GMT

Hi,

Please find the below query.

=IF(Count({<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

Count({<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

** if i select Temp as "Critical" -> It was showing Hot Count

** if i select Temp as "Hot" -> It was showing Critical & Hot Count

please check..

Sub2u444

Re: SetAnalysis Expr checking in Qliksense

sunny_talwar — Fri, 22 Apr 2016 08:08:56 GMT

I would think that it always shows Critical and Hot count even based on any selection in Temp field. If you want to show specific count, try this may be:

=If(Count({<Temp*={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

Count({<Temp*={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

Re: SetAnalysis Expr checking in Qliksense

Fri, 22 Apr 2016 09:55:45 GMT

Sunny Thanks a ton.

Its working fine.

what is the * means .. can you share some info..

Re: SetAnalysis Expr checking in Qliksense

sunny_talwar — Fri, 22 Apr 2016 09:58:02 GMT

* is used for intersection of two sets. In this case the intersection of your current selection and what you have explicitly mentioned to be shown for Temp field (Critical and Hot). So when nothing is selected you see both Critical and Hot, but when you have one or the other selected it will only show the result for that particular selection.