topic Re: Only function in QlikView

Only function

Anonymous — Wed, 07 Jun 2017 12:54:33 GMT

I have chart includes id wise value i.e. only(value)

I want to present the same value in textbox .how we can do that.

sunny_talwar — Wed, 07 Jun 2017 13:00:51 GMT

Is this a single value? Then use Only(value) or just value... if there are multiple of these values do you want to sum them? avg them? concat them?

Anonymous — Wed, 07 Jun 2017 15:12:52 GMT

I tried sum function it gives wrong result as it has multiple values

sunny_talwar — Wed, 07 Jun 2017 15:17:14 GMT

May be this

Sum(Aggr(Only(value), id))

ger_alegria — Wed, 07 Jun 2017 15:19:54 GMT

Use the same expresion Only(Value)

If you have more Values and are num values you can try with max(Value), sum(Value), avg(Value).

If you don't vave num values try with fields functions.

Anonymous — Thu, 08 Jun 2017 04:59:56 GMT

thanku very much

Anonymous — Thu, 08 Jun 2017 05:34:30 GMT

In my real scenario , I have to implement the same using calculated dimension i.e. value list

if I directly use your expression it correct result ,

But if I defined the condition that it should display the value for 4th dimension defined in valuelist it give wrong result

sunny_talwar — Thu, 08 Jun 2017 09:06:38 GMT

May be add NODISTINCT when using it with ValueList

Sum(Aggr(NODISTINCT Only(value), id))