Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Not applicable

Mekko chart support

Hello there,

I am working on this Mekko chart, we are talking here about the split of different companies. in my case, i need to regroup 3 of them (Fnac rive, fnac balexert and Billeterie fnac).

what would be the best thing to do ?

Right now, the dimension is Name_company.

thanks for your help

JP

2015-07-23_08h45_13.png

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Mekko chart support

Hi,

You can group the Company Name in the Backend using Inline Table.

or you can try the calculated dimension like,

=if(WildMatch(Name_company,'*fnac*'),'FNAC(Group Name)',Name_company)

find attached for reference.

View solution in original post

3 Replies
Highlighted
Not applicable

Re: Mekko chart support

Can you expand a bit more of what you end requirement is, maybe knock up an example application or provide a view of how the end result should look.

Joe

Highlighted

Re: Mekko chart support

Hi,

You can group the Company Name in the Backend using Inline Table.

or you can try the calculated dimension like,

=if(WildMatch(Name_company,'*fnac*'),'FNAC(Group Name)',Name_company)

find attached for reference.

View solution in original post

Highlighted
Not applicable

Re: Mekko chart support

i have done the calculated dimension and it works perfectfly