topic Text Box to Display Top Operation Name in QlikView

Text Box to Display Top Operation Name

Mon, 19 Sep 2011 08:53:26 GMT

Hi All,

I have a bar chart that uses an aggregation function to display a value over the dimension "operation". I then use an expression in the sort by tab to order the bar chat in ascending order. This shows me the operation with the highest value

I want a text box that will give me the name of this operation. Thats all

My expression in my chart as I believe you may need this is sum(abc*123)

Thanks,
Byron

Text Box to Display Top Operation Name

SunilChauhan — Mon, 19 Sep 2011 09:05:53 GMT

in text box

max(aggr(sum(abc*123),fieldName))

Text Box to Display Top Operation Name

Mon, 19 Sep 2011 09:10:14 GMT

Hi Byron,

u can create a new straith table sorted and in "Presentation Tab" set 1 in "Max Number (1 - 100)"

or if u want a text box u can use something like "firstsortedvalue Function".

I hope this help you.

C u,

Stefano.

Text Box to Display Top Operation Name

Mon, 19 Sep 2011 09:26:26 GMT

Thanks All

Sunil that function returns a value, I want the name of the dimension value. Ste.san, thanks for that, the firstsortedvalue returns the name of the dimension. Unfortunately this is the smallest value, is there an equivalent to this that returns the value for the highest value???

Thanks,
Byron

Text Box to Display Top Operation Name

Mon, 19 Sep 2011 09:40:59 GMT

Hi,

this is taken from the Help:

firstsortedvalue( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ] expression [, sort_weight [, n]])

returns the first value of expression sorted by corresponding sort-weight when expression is iterated over the chart dimension(s). Sort-weight should return a numeric value where the lowest value will render the corresponding value of expression to be sorted first. By preceding the sort-value expression with a minus sign, the function will return the last value instead. If more than one value of expression share the same lowest sort-order, the function will return null. By stating an n larger than 1, you will get the nth value in order.

So u have to change the sign in the sort-value expression.

C u,

Stefano.