topic Re: Dynamic values in inline table using let variable in QlikView

Dynamic values in inline table using let variable

uacg0009 — Tue, 30 Aug 2016 03:17:47 GMT

Hi all,

I want to make some dynamic values in my inline table, and I know use let variable can make it, but when my variable is complex, I can't get what I want.

My data :

You can also see the value that I want, but I have tried my ways to show that, it didn't work.

What I want is just,

when I choose OWNER = 50, the F1 shows QQQ WWW EEE AAA

when I choose OWNER = 100, the F1 shows QQQ WWW EEE CCC

Could you please help with that? Any questions please feel free to tell me.

Thanks.

Aiolos Zhao

Re: Dynamic values in inline table using let variable

uacg0009 — Tue, 30 Aug 2016 04:52:32 GMT

Anyone have method about this?

Re: Dynamic values in inline table using let variable

sushil353 — Tue, 30 Aug 2016 04:58:42 GMT

Hi,

Please find attached.

you need to create an expression in your list box.

HTH

Sushil

Re: Dynamic values in inline table using let variable

uacg0009 — Wed, 31 Aug 2016 04:12:19 GMT

Hi Kumar,

it works~

Thanks a lot!

Aiolos Zhao