Dynamic grouping of dimensions

[#1]

Hi All,

I have one pie chart in which we  are showing market share by product.

Dimension--> Product

Expression--> Market Share

My requirement is if any product is selected then the chart should change like, if there are 4 products and product A is selected then it should make 2 groups like product A and all the remaining products should be in other group as 'Others'.

Is it possible to make the groups depending on selection like,

Selected product and 'Others'.

Others should include all the other products.

Thanks in Advance..!

[preminqlik]

try with variable like below

vGroup=min(Product)

take dimension below

if(len(Product)>0,if(Product='$(vGroup)','$(vGroup)','Others')            

[preminqlik]

Hi find attachment

[#4]

Hi Prem Kumar Thangallapally,

Our issue is,

In your application file if we select A,B then chart should display three buckets in pie those are A,B,'Others' , in which others will contain C's and D's values (excluded values)

Thanks

[#5]

Hi,

Sorry I have not provided the complete requirement.

Thanks for quick response. Your sample application is working fine if only single product is selected. But its not working if multiple product are selected.

Like if 2 products are selected A and B, then there should be 3 groups. A, B and Others.

Is there any way to do this.

[jagan · Accepted solution]

Hi Priya,

Please find attached file for solution.

Regards,

Jagan.