topic Re: Get value into variable based on condition in QlikView

Get value into variable based on condition

Mon, 22 Sep 2014 15:11:39 GMT

I have table as below-

Tab2:

ID, Description
1, India
2, China
3, USA
4, NY
5, NJ
6, SA

In my variable I want to move particular value.

E.g.

Variable1 = Description where ID = 5.

Variable1 will have value of 'NJ'.

Mon, 22 Sep 2014 16:11:21 GMT

Can any body help on this?

ashfaq_haseeb — Mon, 22 Sep 2014 16:40:38 GMT

Try with this definition

=only({<ID={5}>}Description)

Regards

ASHFAQ

alex_millan — Mon, 22 Sep 2014 16:43:56 GMT

Don't know how to do it in the script but,

Would it be suitable to pass the value after scripting just defining in the variable overview panel?

To define it, would be like this:

=Only({$<ID = {"4"}>} Description)

Hope it helps. Find attached an example.

Regards,

Mon, 22 Sep 2014 17:07:17 GMT

Hi Ashfaq,

Thanks for reply.

Mon, 22 Sep 2014 17:07:57 GMT

Thanks Alex.