topic Re: Max and MIn in set analysis in QlikView

Max and MIn in set analysis

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

i am writing below condition for min and Max in set analysis

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

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

Any idea or suggestion please.

Best Regards,

Re: Max and MIn in set analysis

saar_lorena — Wed, 10 Jul 2019 12:21:11 GMT

As I understood from your formula, you are taking month bigger than 201802 or equal than 201802.

Another solution could be include your column data in your expression as below, instead of using hard code:

=Sum({<Period ={">=$(=min(Period))<=$(=max(Period))"}>}NumValue)

Re: Max and MIn in set analysis

dunnalahk — Wed, 10 Jul 2019 12:38:57 GMT

Hi,

Thank You.

Actually i have min date as 201711 in my report which is my Quarter Q118 starting month , i want to show Quarters only from Q218 so i am giving 201802 which is my Q2 Starting Month.

Re: Max and MIn in set analysis

danilostochi — Wed, 10 Jul 2019 13:20:07 GMT

first transforms the field into the script using monthstart ()