topic Re: Rank Issue in QlikView

Rank Issue

dineshm030 — Thu, 12 Apr 2018 08:55:50 GMT

Hi All,

I selected MUMBAI region. In that region AMARYL M rank is 3. But in main table it is showing as rank 3. I need it should be shown as rank 3.

Could u pls help me.

Thanks in advance.

Re: Rank Issue

dineshm030 — Thu, 12 Apr 2018 08:56:28 GMT

In Main table it showing as rank 1

Re: Rank Issue

sunny_talwar — Thu, 12 Apr 2018 08:58:07 GMT

What is your rank expression look like?

Re: Rank Issue

dineshm030 — Thu, 12 Apr 2018 08:59:41 GMT

but it should be coming based on subgroup.

Aggr(Rank(sum({<IMSMonthName,IMSYear,DATAPERIOD = {">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-11),'YYYYMM')) <=$(=max(DATAPERIOD))"}>}NVALUE),1,1),Region,SUBGROUP)

Re: Rank Issue

sunny_talwar — Thu, 12 Apr 2018 09:02:31 GMT

So what is the link between Region Mumbai and Brands AMARYL M? Why do you need AMARLY M's Rank and why not GEMER?

Re: Rank Issue

dineshm030 — Thu, 12 Apr 2018 09:06:13 GMT

its for example. if i select GEMER it should be as Rank 2

Re: Rank Issue

dineshm030 — Thu, 12 Apr 2018 09:08:21 GMT

here it is in second rank for chennai region

Re: Rank Issue

sunny_talwar — Thu, 12 Apr 2018 09:09:00 GMT

Each Region have only a single Brand?

Re: Rank Issue

dineshm030 — Thu, 12 Apr 2018 09:10:35 GMT

no sunny... it has mutiple brands

Re: Rank Issue

sunny_talwar — Thu, 12 Apr 2018 11:07:42 GMT

I am not sure I understand the Ranks you are looking to get.. would you be able to share a sample and elaborate on the expected output?