topic Re: Using Max and Min functions in set analysis in QlikView

Using Max and Min functions in set analysis

Anonymous — Tue, 06 Feb 2018 06:57:42 GMT

Hi i need to pick max of Date_Actuals from Fact in order to calculate the total Amount from "Amount".

This below expression is not giving any results :

=Sum({<Date_Actuals ={">=$(=min(Date_Actuals))<= $(=max(Date_Actuals))">}Amount)

Please let me know the correct syntax

Thanks in adavance

sunny_talwar — Tue, 06 Feb 2018 16:18:55 GMT

You are missing a closing }... try this:

=Sum({<Date_Actuals ={">=$(=min(Date_Actuals))<=$(=max(Date_Actuals))"}>}Amount)

dunnalahk123 — Mon, 08 Jul 2019 16:58:48 GMT

Hi Sunny,

Same expression i am trying to use as below

My point is Q118 should not come as i am taking month greater than 201802 which Q2FY18 , but for me Q118 is coming and data is coming as 0.

Any idea or suggestion please.

Sum({<Month ={">=201802 <=201904"}>}NumValue)

Best Regards,