Create calculated dimension in qliksense

[Rsaiq]

HI Experts,

I have a reuirement in qliksense as need  2 field to merge into one. I am explaining in details as below:

I have 2 existing fields

Now as per the requirement We need to merge fields with some calculations like below

 

So When i am clicking on BBB or clicking on Individual then it is working fine. But when clicking on BBB Income or BBB Cover or BBB Asset it is also selecting BBB

Could you please tell me how to ignore BBB when selecting BBB Income or BBB Cover or BBB Asset 

Thanks in advance.

[Rsaiq]

Hi @ajaykakkar93 

Just 1 last request from you , could you please explain me little bit here as how the link table working here.

Thank You

[ajaykakkar93]

Sure,
The following link will provide you with a brief overview of the topic.

https://www.ometis.co.uk/concatenate-link-tables-qlik/#:~:text=A%20link%20table%20resolves%20the,bet....

Youtube:

https://www.youtube.com/watch?v=YhrcnkHdc3A

Note: We are creating values that fit our logic. For example, BBB should have the following values, so we mapped them accordingly.

1. Income
2. Cover
3. Asset