Current selection display

[ashis]

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.

[jubarrosor]

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

[YoussefBelloum]

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 ?

[sudhirpkuwar]

why dont you do this at the script

like Flag as xxx instead of 1

[ashis]

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

[ashis]

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.

[ashis]

Hi Youssef ,

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

[sasiparupudi1 · Accepted solution]

use dual

Table1:

.....

Dual('xxx',1) as Flag

Table1:

.....

Dual('yyy',1) as Flag

[jubarrosor]

You can use codes not numbers:

Table1:

...

'xxx' as Flag

....

Table2:

'yyy' as Flag

...

Table3:

'zzz' as Flag

...

Best Regards,

Juan P. Barroso

[ashis]

Thank you Sasidhar, it worked .