topic Re: finding max & Min Month dynamically in QlikView

finding max & Min Month dynamically

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

Hi All,

I am having a 2 list boxes such as Period 1 & Period 2. So when user selects different months in this list boxes I need to show the delta values between months. For Ex : If user selects Sep 2017 from Period 1 and Oct 2017 from Period 2 ,then I need to show the delta values between these two months.

However if any of the user selects multiple months, I need to show the Max (Month) from Period 2 and Min(Month) from Period 1.

I have attached sample file. Kindly let me know with your solution

Thanks,

Jai

Re: finding max & Min Month dynamically

Clever_Anjos — Mon, 30 Oct 2017 13:12:24 GMT

you should create your fields as numbers, not text, so you could use something like this

sum({<Month={">=$(=Max(Period1))"}*{"<=$(=Max(Period2))"}>}Value)

Re: finding max & Min Month dynamically

swuehl — Mon, 30 Oct 2017 13:15:37 GMT

Try like this:

Load your Month values as dates in the script.

Then replace GetFieldSelections() with MinString() resp. Maxstring() in your expressions.