topic Re: Get Dimension Value in Textbox in QlikView

Get Dimension Value in Textbox

Mon, 01 Oct 2012 08:06:01 GMT

Hi all,

Anyone know how to get dimension value in textbox?

For example i have table :

Country Value

A 500

B 1000

C 2000

D 300

E 1200

I want to show country with the lowest value (for ex) in textbox. Is it possible?

The textbox must be like this:

"Country with lowest value is : D"

Or have any idea to solve this?

Thanks.

swuehl — Mon, 01 Oct 2012 08:16:24 GMT

Try something like

=FirstSortedValue(Country, Value)

as expression in your textbox. For max Value, use

=FirstSortedValue(Country, -Value)

Hope this helps,

Stefan

Mon, 01 Oct 2012 08:35:55 GMT

thanks swuehl for your response.

it work! thanks. but what the expression if i want to show 2 or 3 value?

for ex: D, A , and B ??

swuehl — Mon, 01 Oct 2012 08:39:34 GMT

FirstSortedValue takes a third argument where you can define which value in sort order should be returned

=FirstSortedValue(Country, Value, 2)

=FirstSortedValue(Country, Value, 3)

return the Country with second / third smallest Value). Please refer to the HELP for more detail.

Mon, 01 Oct 2012 09:04:29 GMT

ok thanks swuehl for your help.