topic Possible selections from a different field in QlikView

Possible selections from a different field

stevejones1 — Tue, 08 Aug 2017 19:05:20 GMT

I have 2 Fields, Dim key and Source Key .. i have a search box on Source Key .. i want to display all the Source Keys associated with the same Dim Key .. as in the below example when user selects CDF , both CDF and LMN has to be selected because they share the same Dim Key .. how can i achieve this?

Dim Key Source Key

4 CDF

4 LMN

1 ABC

Thank you!

Re: Possible selections from a different field

sunny_talwar — Tue, 08 Aug 2017 19:06:53 GMT

Using set analysis, you can do this

{<[Source Key], [Dim Key] = p([Dim Key])>}

Re: Possible selections from a different field

stevejones1 — Tue, 08 Aug 2017 19:44:18 GMT

where should i use this ?

This is my expression for displaying the Source Key as a link in my table .. i dont have any other expression other than this one for my table ..

[Source Key]&'<URL>'&'https://abc/browse/'&[Source Key]

Re: Possible selections from a different field

stevejones1 — Tue, 08 Aug 2017 19:51:21 GMT

How do i enable the selections in the whole application ? i basically want to have this in field event triggers .. so that i select a source key from search box , which enables fields selection in dim key which triggers associated source keys .. is that possible?

Re: Possible selections from a different field

sunny_talwar — Tue, 08 Aug 2017 19:53:04 GMT

May be like this

Only({<[Source Key], [Dim Key] = p([Dim Key])>} [Source Key]&'<URL>'&'https://abc/browse/'&[Source Key])

Re: Possible selections from a different field

stevejones1 — Wed, 09 Aug 2017 04:18:17 GMT

Using the above expression i am able to resolve the issue for one table but i have many charts .. so i am looking for a way to enable this through out the application.If thats not possible please suggest a way to do this individually for each chart.Attaching my application , search the value "QBO-174575" in the search .. you would be able to see 2 source jira keys associated with each other by one dim jira key .. in the table (screen shot below).. this specific key is open on 6/19 and closed on 7/6 ..so i want to display 6/19 in find vs fix chart .

Find on 6/19 and Fixed on 7/6 .. as of now only fix is display because i filtered on QBO - 174575

Re: Possible selections from a different field

stevejones1 — Fri, 11 Aug 2017 17:46:17 GMT

Is the below possible?