Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

RANK Formula

Hi,

So I have a dataset with the following dimensions:

MARKET; BRAND; LAB; MOLECULE; SALES TYPE (UNITS OR LOCAL CURRENCY); PERIOD

and the following measures: 1; 2 (based on the sales value for period1 and previous period (2))

I created a Pivot Table in Qlik Sense with the following parameters:

Rows: BRAND

Columns: SALES TYPE; PERIOD; MEASURES

Measures: Sum([1]), MS%1

MS%1 (Market Share in period1) is calculated the following way:

aggr(NODISTINCT {<BRAND, MOLECULE, LAB>} sum([1]),BRAND, PERIOD, [SALES TYPE])/aggr(NODISTINCT {<BRAND, MOLECULE, LAB>} sum([1]),MARKET, PERIOD, [SALES TYPE])

I need to create a RANK measure on the Master Items based on MS%1. Could you please help me to elaborate the formula? I cant get it to work.

Thanks!

Tags (1)
2 Replies

Re: RANK Formula

Would you be able to provide a sample to explain what you are trying to do?

Not applicable

Re: RANK Formula

Thanks for your reply,

I already got it using this formula:

Rank(TOTAL Aggr((Sum([1])), [SALES TYPE], PERIOD, MARKET, BRAND),0,1)

Best!