topic Re: From multiple expression bar chart, how to capture the selected bar expression. in QlikView

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

antonymaddy — Tue, 01 Oct 2019 07:34:28 GMT

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.

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

Arthur_Fong — Tue, 01 Oct 2019 08:12:37 GMT

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

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

antonymaddy — Tue, 01 Oct 2019 10:02:58 GMT

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.

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

Arthur_Fong — Wed, 02 Oct 2019 00:02:23 GMT

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