topic Re: Alternate state refer to a single data point in QlikView

Alternate state refer to a single data point

Fri, 07 Nov 2014 20:08:45 GMT

Hi, is it possible to refer to a single data point in an alternate state?

For example, if I want to sum something up on an alternate state then it would be something like

=sum({Alternate State} revenue)

but what if I want to address it without a sum function, such as {Alternate State} revenue?

Thanks!

Re: Alternate state refer to a single data point

danieloberbilli — Fri, 07 Nov 2014 20:16:51 GMT

if there is only one value available in the field, you could use only(). Max()/Min()/Minstring() would also look for a single value

Re: Alternate state refer to a single data point

Fri, 07 Nov 2014 22:04:11 GMT

thanks for your suggestion Daniel - so I assume there's no way to extract a single data point in an alternate state without a function being involved (min, max, only, sum, etc.)

Re: Alternate state refer to a single data point

danieloberbilli — Fri, 07 Nov 2014 22:09:12 GMT

As long as you are dealing with values in fields you need some kind of function to identify this single value. But you could also set a variable in the scripting and use this in the frontend.

Maybe describe a bit whats your situation (input data/structure) and what you would like to achieve what is currently not working