Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

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
Not applicable
Author

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

settu_periasamy
Master III
Master III

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.

Not applicable
Author

i have done the calculated dimension and it works perfectfly