topic Re: FirstsortedValue and Current selection issue in QlikView

FirstsortedValue and Current selection issue

Manish — Thu, 30 Jan 2020 13:35:59 GMT

Hi All

I have written the below mentioned expression to get branch where the count is max , which is working fine.

FirstSortedValue(Branch,-aggr(Count(DISTINCT{<DateFlag={'ReSub'},Id={"=Sum({<DateFlag={'ReSub'}>}[No Of Resubmission])<>0"}>} Id),Branch))

Now i dont want my output to be impacted or changed on a selection of a branch.

How can i achieve that ??

any help would be appreciated.

Many thanks

Re: FirstsortedValue and Current selection issue

Anil_Babu_Samineni — Thu, 30 Jan 2020 13:45:19 GMT

Perhaps this

FirstSortedValue({<Branch>} Branch,-aggr(Count(DISTINCT{<Branch, DateFlag={'ReSub'},Id={"=Sum({<Branch, DateFlag={'ReSub'}>}[No Of Resubmission])<>0"}>} Id),Branch))

FirstSortedValue(Only({<Branch>} Branch),-aggr(Count(DISTINCT{<Branch, DateFlag={'ReSub'},Id={"=Sum({<Branch, DateFlag={'ReSub'}>}[No Of Resubmission])<>0"}>} Id),Branch))