11 Replies Latest reply: Dec 3, 2015 8:10 AM by xavier hemelaar RSS

    How to merge 2 dimensions

    xavier hemelaar

      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!