rank items by their Sales value

Hakim — Sat, 16 Nov 2024 05:07:24 GMT

Hello every one,

I am trying to create a pivot table using the sample app of Qlik Cloud 'Supply Chain - Inventory & Product Availability'.

My table has two dimensions: Brand and [Item Name], when a store is selected in the filter this table will show the Sales value of each item and the rank of the sales value of each item based on the sales value of the same item in the other stores

For the rank column I use this formula: aggr({<[Long Store Name]=>}rank(total Sum([EPOS Sales])),[Long Store Name])

This formula gives me the right rank value, the problem that I am facing is that this formula works only when I select an item (see rank_1.png), otherwise it gives me a null value for all items (see rank_2.png).

Can anyone help me to get the rank of sales value of an item in a store compared to the sales value of the same item in the other stores.

Re: rank items by their Sales value

sunny_talwar — Wed, 07 Aug 2019 18:12:50 GMT

May be try this

Aggr( Rank(Sum({<[Long Store Name]>} [EPOS Sales])) , [Brand], [Item Name], [Long Store Name])

Re: rank items by their Sales value

Hakim — Thu, 08 Aug 2019 08:38:00 GMT

Hi sunny_talwar,

Your solution works perfectly !

Thank you,

Hakim

topic Re: rank items by their Sales value in App Development

rank items by their Sales value

Re: rank items by their Sales value

Re: rank items by their Sales value