Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with get field selection

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

4 Replies
Anonymous
Not applicable
Author

Hola,

If BUHEAD and BUHEAD_INITIATIVE have same data then why don't create a link?

Anonymous
Not applicable
Author

Due to the Current data structure of my dashboard I am unable to do that

Anonymous
Not applicable
Author

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.

timanshu
Creator III
Creator III

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.