topic Re: Re: Get minimum values from a data set and display in straight table in QlikView

Get minimum values from a data set and display in straight table

anuradhaa — Fri, 23 Aug 2013 08:25:57 GMT

Hi,

Pls chk my attached xcl sheet. There i have prices to destination to origin with different suppliers.

So what i need to get is the minimum origins supplier wise.

exp 1 - =min({<Supplier={'A'}>}PRICE)

exp 2 = =min({<Supplier={'B'}>}PRICE)

and i have used destination as dimension.

i have use below expression and i can get the prise for it, but i can't include associated origin in that chart.

Plz help.

Brice-SACCUCCI — Fri, 23 Aug 2013 08:45:44 GMT

Hi,

can you try FirstSortedValue(Origin, Prise) ?

Regards,

Brice

Fri, 23 Aug 2013 08:58:29 GMT

Hi,

See the attachment.

anuradhaa — Fri, 23 Aug 2013 09:00:57 GMT

Thanks all.

That one solve my problem.

Thank you very much