Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Geniuses,
I have two different tables in one table I have
First table BUHEADDESC and BUHEAD
Second Table BUHEAD_INITIATIVE
User selects BUHEADDESC this BUHEADDESC has unique BUHEAD
I want the same BUHEAD in BUHEAD_INITIATIVE to be picked up either in variable or get selected in List box
Two tables are not related , you can say that they are data Island
Thanks in advance
Shashank
Hola,
If BUHEAD and BUHEAD_INITIATIVE have same data then why don't create a link?
Due to the Current data structure of my dashboard I am unable to do that
Hi Shashank,
Any particular reason to not having the relationship between table ? if not -
If both table have same value for BUHEAD
- then first thing you need to do is - rename your column with same name 'BUHEAD' (so that qlikview can do the association b/w the tables)
If you dont want to have the link b/w table still want to use the value .. you can use get GetFieldSelections(BUHEAD) as your both tables having the same value for this column and use this value for your requirement.
It can be picked up in variable.
Just assign BUHEAD as epression to variable.
Let's say 'var' is variable, then assign =BUHEAD to this variable.
This variable will give output of unique BUHEAD according to selected BUHEADDESC .
But this will give null if you select multiple values to BUHEADDESC.