Expression in chart - MAX record between dates with multiple conditions

Sai78 — Mon, 21 Sep 2020 05:21:49 GMT

I have requirements to display the max record when multiple conditions satisfy in the chart based on date selections..the main identifier has multiple records, so If I run the chart by selecting all the available dates it works fine as my date set to have a rank column which already calculated record how many times appears .. however if using the below expression and running this on the limited time frame I'm missing the records.

So my requirements here is whatever the time frame I selected I need the recent record at that time ...

=Count(distinct if( [Type]='test' and Status='Complete' and match(Type2, 'first',second')and rank=1 and DateType ='CreatedDate' and (Date>=DayName(vSDt) and Date<=DayName(vEDt)) , Key))

Any help would be greatly appreciated .. Thanks in advance.

Re: Expression in chart - MAX record between dates with multiple conditions

Brett_Bleess — Wed, 14 Oct 2020 17:08:43 GMT

Believe this is going to likely require some set analysis too, so providing a few links that I hope may be of some help:

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

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

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Sorry I am not more help, this will kick things back up as well, and someone else may offer up something else, but one thing that would definitely help on this one is a sample QVW so folks can see things in more detail...

Regards,
Brett

topic Expression in chart - MAX record between dates with multiple conditions in QlikView

Expression in chart - MAX record between dates with multiple conditions

Re: Expression in chart - MAX record between dates with multiple conditions