topic Get dimension against highest spend in QlikView

Get dimension against highest spend

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

Hi Everyone,

I have a list of hotels(along with city) and the amount spent in each for a particular date. I would like to display the top hotel city with the highest spent for the month selected in the list box.

Thanks

Anagha

Re: Get dimension against highest spend

tamilarasu — Fri, 01 Jul 2016 02:55:50 GMT

May be this,

='Top hotel ' & Only({<[Hotel Name] = {"=Rank(Sum([Amount]))=1"}>} [Hotel Name]) & chr(13) & Sum({<[Hotel Name] = {"=Rank(Sum([Amount]))=1"}>} [Amount])

Re: Get dimension against highest spend

susovan — Fri, 01 Jul 2016 04:39:43 GMT

Hi Anagha,

Try this attachment,

Re: Get dimension against highest spend

anagharao — Fri, 01 Jul 2016 06:49:28 GMT

Hi Thank you for the solution. Much appreciated

Can you help me in extending the solution to compare top city of this month with its spend in the previous month?

Regards,

Anagha