topic Re: Conditional Expressions on a Bar Chart in QlikView

Conditional Expressions - Bar Chart

qlikwiz123 — Sat, 16 Nov 2024 03:29:25 GMT

I have a bar chart which has Funds broken down into Category A and B.

I need to hide and show based on certain conditions.

1. If no selections are made on 'Category', then the bars should show sum of all the Funds.

Refer to my Result table. It shows all the funds in one bar broken down into Quarters, but the years are hidden for some reason. No idea why.

2. If I select 'A', only bar for 'A' should show up and if I select 'B', only bar for B should show up. If I select both A and B, then two bars for each category has to be shown instead of one combined bar.

Right now, it is done but I have the same issue. Years is being hidden. I want to break down the Funds into Quarters and Years.

Re: Conditional Expressions on a Bar Chart

sunny_talwar — Thu, 23 May 2019 17:03:34 GMT

Can you check to see if attached is what you are looking to do?

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 17:18:12 GMT

@sunny_talwar Hi Sunny, when nothing is selected in category, I need to show just two bars per quarter but no stacking( Should be of same color and total value).

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 17:23:14 GMT

I think I got it. I enabled my third expression and added similar conditions to hide and show. The answer to my problem was a dummy third dimension which is '=1' you used 🙂

Thank you so much.

Re: Conditional Expressions on a Bar Chart

sunny_talwar — Thu, 23 May 2019 17:25:22 GMT

Super, I am happy you were able to figure it out 🙂

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 17:30:44 GMT

🙂

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 17:34:27 GMT

@sunny_talwar Small help.

I have another chart with YTD values and ValueList is being used. I am not sure how to implement the same logic on this chart. I have attached the QVW with the YTD chart added. Any help with this is really appreciated 🙂

Re: Conditional Expressions on a Bar Chart

sunny_talwar — Thu, 23 May 2019 17:39:03 GMT

Attached where? a new thread?

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 17:49:53 GMT

Here it is

Re: Conditional Expressions on a Bar Chart

sunny_talwar — Thu, 23 May 2019 17:44:10 GMT

Is this the chart?

What is wrong?

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 17:52:26 GMT

I need to show one color bar (Combined A+B) for each year when no selections are made on Category. But when I select 'A' in Category, the Category A bar in Green should show up for 2018 and 2019 (two bars) and if I select Category 'B' is selected, one bar each for 2018 and 2019 for 'B' should be shown. And if I select both 'A' and 'B', then stacked bars with both 'A' and 'B' with two colors should be shown. Just like the Result table.

Please refer to the revised QVW

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 17:56:15 GMT

@sunny_talwar

Also, is there any way I can hide the empty bars in the previous chart?

Re: Conditional Expressions on a Bar Chart

sunny_talwar — Thu, 23 May 2019 18:04:59 GMT

Do you want to may be list 10 more requirements at the same time 😉. Lol, I am having difficulty understanding one requirement, but you are pilling them all up....please go slow... I am new to your dashboard and very new to your requirement

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 18:06:22 GMT

Haha. Sorry. These charts have been killing for for few days now, especially the conditional hide show parts.

Re: Conditional Expressions on a Bar Chart

sunny_talwar — Thu, 23 May 2019 18:12:48 GMT

Check now

Re: Conditional Expressions on a Bar Chart

qlikwiz123 — Thu, 23 May 2019 18:46:38 GMT

@sunny_talwar Thank you sir