topic Re: Current selection display in QlikView

Current selection display

ashis — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am pulling data from 3 different tables and at the end i am merging all three tables data

to understand which data is from which table i am using a flag and adding it in the merge load script

Table1:

.....

1 as Flag

Table2:

.....
2 as Flag

Table3:

....
3 as Flag

then in my dashboard i am using this Flag as list box

=IF(FLAG=1,'xxx',IF(FLAG=2,'yyy',IF(FLAG=3,'zzz')))

Problem is in the current selection box it is show as
Flag:1 or Flag:2 or Flag:3 based on my selection

I want to display in the current selection box as

xxx , yyy or zzz

How can i achieve it.

Re: Current selection display

jubarrosor — Wed, 09 May 2018 10:12:03 GMT

Hi Ashis:

You can use only one flag with 3 diferentes values 1,2 y 3.

Table1:

...

1 as Flag

....

Table2:

2 as Flag

...

Table3:

3 as Flag

...

Best Regards,

Juan P. Barroso

Re: Current selection display

YoussefBelloum — Wed, 09 May 2018 10:12:09 GMT

Hi,

it is still not very clear I think.. would you be able to attach screen shot or sample app to see what you have so far ?

Re: Current selection display

sudhirpkuwar — Wed, 09 May 2018 10:14:51 GMT

why dont you do this at the script

like Flag as xxx instead of 1

Re: Current selection display

ashis — Wed, 09 May 2018 10:17:28 GMT

Hi Juan,

Sorry for not being clear from my above statement.

Actually I am doing the same as you said.

Now in the current selection box I see Flag:1 or Flag:2 or Flag:3 as selection , how can I change the display of this .

I want to show Flag:xxx or Flag:yyy or Flag:zzz

Re: Current selection display

ashis — Wed, 09 May 2018 10:18:44 GMT

Thank you Sudhir,

I want to keep it numeric instead of string value .

Is there any way I can change it in the display of current selection.

Re: Current selection display

ashis — Wed, 09 May 2018 10:23:29 GMT

Hi Youssef ,

Sorry for the confusion, I have reposted it . Please have a look.

Re: Current selection display

sasiparupudi1 — Wed, 09 May 2018 10:23:59 GMT

use dual

Table1:

.....

Dual('xxx',1) as Flag

Table1:

.....

Dual('yyy',1) as Flag

Re: Current selection display

jubarrosor — Wed, 09 May 2018 10:28:15 GMT

You can use codes not numbers:

Table1:

...

'xxx' as Flag

....

Table2:

'yyy' as Flag

...

Table3:

'zzz' as Flag

...

Best Regards,

Juan P. Barroso

Re: Current selection display

ashis — Wed, 09 May 2018 10:41:29 GMT

Thank you Sasidhar, it worked .