How to merge 2 dimensions

[reivax31]

Hi Qlikers,

I'm trying to find a way to merge 2 dimensions based on 2 conditions. For this I'm using Wildmatch but it doesn't work yet....

I have 2 dimensions [Dimension1] and [Dimension2]

[Dimension1]        [Dimension2]

CAT                       OTHER

CAT                       OTHER

CAT                       OTHER

OTHER                 OTHER

OTHER                 CAT

OTHER                 OTHER

...

if(wildmatch([Dimension1],'CAT'),'CAT',if(wildmatch([Dimension2],'CAT'),'CAT','OTHER')) .... But it doesn't work.

Any idea how I can merge this in the front end?

Thanks for your support!

[reivax31]

Hi Kush,

When I try your solution this is what happens when i qlik on my bloc "CAT" the filter that will appear in the filter bar are:

[Dimension1]  =ALL (CAT+OTHER)   and [Dimension2]  = CAT

[Dimension1]        [Dimension2]

CAT                       OTHER

CAT                       OTHER

CAT                       OTHER

OTHER                 OTHER

OTHER                 CAT        --> result

OTHER                 OTHER

[reivax31 · Accepted solution]

Hi, I think it is just not possible to do what I want in dimensions. Because if I select my block "CAT" in the treemap, it will automaticaly trigger the 2 filters ([Dimension1] & [Dimension2]). And there is no logical way to filter on both to do what I want. I guess I will have to change all my measures in each graph by counting all the fields with 'CAT'. Or I have to add a conversion table to make it work...