From multiple expression bar chart, how to capture the selected bar expression.

[antonymaddy]

Hi All,

I got a requirement from my user like, By default I need to show month wise chart (with 4 expressions) it will display 4 bar,

once I click on any bar it should drill to location wise, This much I have done.

But now his requirement is , When I click on any bar in month wise it should drill to location wise but he need to see only the selected bar need to excluded other 3 bars.

Is it is possible in Bar Chart. 

Kindly suggest if you guys have any solution.

[Arthur_Fong]

Is this the expected output?

You would need to build a table with the full list of expressions names(KPI in this example) in the table. 

Select this column as your dimension, along with Month dimension:

In expression, pick(match) all expression logics:

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[antonymaddy]

Thanks for your quick response.

Actually the expected out put should be like this.

This is my default view.

Now when I click on the third bar it should be drilled to location wise and the output should be like below screenshot.

[Arthur_Fong · Accepted solution]

Using the same concept as above, continue on creating drill down dimensions:

Go to Chart Properties > Dimensions > Edit Group (lower left) >  Add in your dimensions based on hierarchy.

When the specified KPI is selected, it will display the next level of dimension:

Refer to qvw attached as reference.

Thanks and regards,

Arthur Fong