topic Re: Conditional and ID in QlikView

Conditional and ID

Thu, 10 Sep 2015 09:28:09 GMT

Hi everyone:)

I have an question.

for example:

ID name

1 Fabian

2 andre

3 saskia

4 max

I have a variable:

vID = ID

vID2 = ID-1

vID3 = ID-2

so now, I need to select a id = for example 3 for saskia but I like also a textbox with the variable vID2...

my solution but it's not working:

if(ID = $(vID2), name)

it's not working ... what now?

alex_millan — Thu, 10 Sep 2015 09:32:09 GMT

Guess you want to select an ID and have the name for the ID-1 shown in a textbox?

If so, try to put the expression in the textbox:

=Only({<ID = {$(vID2)}>}name)

So you can reference the name to the ID corresponding to the variable vID2

Hope that helps

Regards

sunny_talwar — Thu, 10 Sep 2015 09:38:38 GMT

Minor correction in the expression:

=Only({<ID = {$(vID2)}>}name)

alex_millan — Thu, 10 Sep 2015 09:41:39 GMT

Thanks Sunny!!! I really missed it. Edit in my previous post.

sunny_talwar — Thu, 10 Sep 2015 09:43:18 GMT

Awesome

Thu, 10 Sep 2015 09:46:09 GMT

THANK YOU