topic Problem with get field selection in QlikView

Problem with get field selection

Anonymous — Thu, 19 Feb 2015 06:11:21 GMT

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

Re: Problem with get field selection

Anonymous — Thu, 19 Feb 2015 06:21:55 GMT

Hola,

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

Re: Problem with get field selection

Anonymous — Thu, 19 Feb 2015 06:32:24 GMT

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

Re: Problem with get field selection

Anonymous — Thu, 19 Feb 2015 06:41:23 GMT

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.

Re: Problem with get field selection

timanshu — Thu, 19 Feb 2015 06:47:38 GMT

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.