Display value from field

Wed, 22 Jan 2014 14:34:21 GMT

Hi all,

A simple question, how can I just show the value from i field in a syntax like this:

??????({$<WeekCounter={">$(#=max(WeekCounter-4))"}}>} Head_goal)

Head_goal has values like 97,0. So I don't need sum or count any value.

Thanks!

Re: Display value from field

Nicole-Smith — Wed, 22 Jan 2014 14:38:28 GMT

I think you may be looking for the only() function:

only([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression)

If expression or field iterated over the chart dimension(s) contain one single value, that value is returned, else NULL is returned. Only can return numeric values as well as text values.

Examples:

only( Sales )

only( Price*Quantity )

only( total Salesman )

However, if you have more than one value, you may want to use concat() as only() will not show anything if there is more than one value in the field.

topic Display value from field in QlikView

Display value from field

Re: Display value from field