topic Re: Min Rank in QlikView

Min Rank

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

this is for Max rank , how to display lowest rank . i change to -1 somehow its not working

=concat ( distinct IF( aggr ( Rank(Count (DISTINCT [ user])), [Date Time])<=1,

[Date Time] ), ', ' , num([Date Time]))

Re: Min Rank

sunny_talwar — Mon, 05 Dec 2016 20:57:55 GMT

May be this:

=Concat (DISTINCT If(Aggr(Rank(-Count(DISTINCT [ user])), [Date Time]) <= 1, [Date Time]), ', ' , Num([Date Time]))

Re: Min Rank

everest226 — Mon, 05 Dec 2016 21:12:19 GMT

=concat ( distinct IF( aggr ( Rank( Count (DISTINCT {<Year={'$(=max(Year))'}, Month={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month)-1,'MM')))"}>}[ user])), [Date Time])<=1,

[Date Time] ), ', ' , num([Date Time]))

i was able to get rank 1 by following but when i try - in front of count it dosent work.

basically set analysis is to get current year last months data

Re: Min Rank

sunny_talwar — Mon, 05 Dec 2016 21:59:35 GMT

Can you create a chart

Dimension

[Date Time]

Expression

Rank(-Count (DISTINCT {<Year={'$(=max(Year))'}, Month={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month)-1,'MM')))"}>}[ user]))

What do you get?

Re: Min Rank

everest226 — Mon, 05 Dec 2016 22:29:40 GMT

I get the lowest value but when i tried following on the text object it does not show any value

=concat ( distinct IF( aggr ( Rank( -Count (DISTINCT {<Year={'$(=max(Year))'}, Month={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month)-1,'MM')))"}>}[ user])), [Date Time])<=1,

[Date Time] ), ', ' , num([Date Time]))

Re: Min Rank

sunny_talwar — Mon, 05 Dec 2016 22:33:48 GMT

Are you expecting more than one value?? What is the reason to use Concat here if you are looking for Rank 1? May be you need < 2 instead of <= 1? I am just throwing out different ideas... not sure what might be causing this

Re: Min Rank

everest226 — Mon, 05 Dec 2016 22:48:05 GMT

Yep expecting more than one value,.i am trying to capture lowest users visited to the dashboard by date time in last months of current year. was able to get highest but somehow lowest is not showing up.

Re: Min Rank

Anshu_Saxena — Thu, 30 Sep 2021 14:15:06 GMT

Hi Sunny,

Can we calculate Min or Max Rank from Rank measure in Qliksense. I am struggling on this since last 2 weeks as I am just starter for Qliksense.

Thanks,

Anshu