topic Re: finding min and max status in expression in QlikView

finding min and max status in expression

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

Hi Friends,

I have a Requirement like The Below

when user select multiple month we need to take min status and max status

then we need to compare whether status is same if status is same we need not count

Ex:--if u select jan and feb month jan min status is positive and feb max status is feb

this senario we need not count

could any one suggest me the best solution

Thanks

Input

sunny_talwar — Thu, 22 Dec 2016 11:51:49 GMT

How are you estimating the status? based on dates?

May be this:

If(FirstSortedValue(PREVCLUSTER, -MonthYear) = FirstSortedValue(PREVCLUSTER, MonthYear), 1, 0)

lironbaram — Thu, 22 Dec 2016 11:58:30 GMT

this should work for you

=sum(aggr(if(only({<MonthYear={'$(=min(MonthYear))'}>}CURR_FOR_STATUS)<>only({<MonthYear={'$(=max(MonthYear))'}>}CURR_FOR_STATUS),1,0),ACCOUNT_ID))

krishna20 — Thu, 22 Dec 2016 12:11:45 GMT

yes

your correct

sunny_talwar — Thu, 22 Dec 2016 12:27:58 GMT

So is the above expression working or not?