Two Selection Should be Interlinked

[mhmmd_srf]

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

[sunny_talwar · Accepted solution]

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

[ahaahaaha]

Hi,

Maybe just bookmarks?

Regards,

Andrey

[tresesco]

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.

[mhmmd_srf]

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

[sunny_talwar]

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