topic Two Selection Should be Interlinked in QlikView

Two Selection Should be Interlinked

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I have two selection:

Sales_Fact_ProductGroupMajor and Units_Fact_ProductGroupMajor.

Those are coming from different table.

I want to make such behavior in Qlik:

If I select 002 from Sales_Fact_ProductGroupMajor, then Units_Fact_ProductGroupMajor also should be selected and vice versa.

I am attaching the App.

Could you please check and let me know any way.

Please help. This is very imp.

Thanks,

Sarif

Re: Two Selection Should be Interlinked

sunny_talwar — Wed, 05 Apr 2017 08:00:54 GMT

Check now... added a trigger for both your field

Re: Two Selection Should be Interlinked

ahaahaaha — Wed, 05 Apr 2017 08:01:02 GMT

Hi,

Maybe just bookmarks?

Regards,

Andrey

Re: Two Selection Should be Interlinked

tresB — Wed, 05 Apr 2017 08:05:45 GMT

PFA

I have applied trigger to resolve your issue. However, this solution is not an elegant one, instead, you should resolve it in the data model.

Re: Two Selection Should be Interlinked

mhmmd_srf — Wed, 05 Apr 2017 08:14:32 GMT

Hey Sunny,

I got the idea. Thanks a lot sir.

One small thing.

If I select 002 from Sales_Fact_ProductGroupMajor, 002 is also selected in Units_Fact_ProductGroupMajor.

Now if I want to back. I need to click twice to deselect both.

Is there any way to deselect both field in single qlik on Back button.

Because I need to hide one of them. Will show only one selection at a time.

Secondly could you please explain why we are using Concat funtion here?

Please help.

Thanks,

Sarif

Re: Two Selection Should be Interlinked

sunny_talwar — Wed, 05 Apr 2017 09:40:45 GMT

To answer your 1st question, I don't think you can do anything about it.... For the explanation about the second question, the Concat is needed if you plan to select more than one value. If you select just 1 value, then you might be able to get rid of the whole concat thing.

Also, look here:

Example of Selecting Multiple Field Values