topic Re: Multiple dimensions in bar chart in QlikView

Multiple dimensions in bar chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a bar chart with dimensions conditionally changing based on the filter selections. I have used calculated dimension option to do this.

I got the expected result in my chart, but when I click on a bar in bar chart it shows "No data to display".

How can I solve this guys, please help. Attached my sample qvw.

Thanks,

Siva.

Re: Multiple dimensions in bar chart

sunny_talwar — Mon, 28 Aug 2017 12:49:40 GMT

Try the attached

Re: Multiple dimensions in bar chart

Or — Mon, 28 Aug 2017 12:52:25 GMT

When you click on the chart, you're effectively changing the selections your chart is based on. This in turn makes your calculated dimension invalid, as you've the if() statements in a way that doesn't accept multiple selections.

You could take one of three approaches:

* Disable in-chart selections (Under General, tick the "Read Only" box)

* Re-write your chart to use multiple dimensions with conditions to hide the ones that are not desirable based on the selections.

* Set your list boxes to "Always one selected", which will prevent the multi-selection override when clicking in the chart.

Given that you haven't explained what behavior you expect when the chart is clicked, I'm not sure if this is helpful.

Re: Multiple dimensions in bar chart

Anonymous — Mon, 28 Aug 2017 12:56:03 GMT

Thanks Sunny. I've tried this but I also want to sort the dimensions by expression wise. In this case, I can't achieve this.

Re: Multiple dimensions in bar chart

sunny_talwar — Mon, 28 Aug 2017 12:58:05 GMT

Can you elaborate on what you mean by this?

Re: Multiple dimensions in bar chart

Kushal_Chawda — Mon, 28 Aug 2017 12:59:07 GMT

je baat

Re: Multiple dimensions in bar chart

Anonymous — Mon, 28 Aug 2017 13:01:41 GMT

Attached QVW. Please have a look at sort tab in this bar chart, I wanted to show this as waterfall bar chart. In this case, the solution that you provided is not useful.

Please suggest some other way if any?

Re: Multiple dimensions in bar chart

sunny_talwar — Mon, 28 Aug 2017 13:07:16 GMT

Are you talking about the bar offset or sorting problem? Sorting seems right to me... no?

Re: Multiple dimensions in bar chart

Anonymous — Mon, 28 Aug 2017 13:12:23 GMT

Sunny,

Actually I want this bar chart(attached in qvw). I've got this, but in this chart I couldn't make a single or multiple bar selection(shows "No data to display").

Re: Multiple dimensions in bar chart

sunny_talwar — Mon, 28 Aug 2017 13:15:38 GMT

I get that, but with the alternate solution you were able to select, right? What is the problem with using what I provided you?

Re: Multiple dimensions in bar chart

Anonymous — Mon, 28 Aug 2017 13:18:41 GMT

I can sort it as shown below, if I use calculated dimension

If I use multiple dimensions as suggested by you, I couldn't sort by multiple dimensions right?

Re: Multiple dimensions in bar chart

sunny_talwar — Mon, 28 Aug 2017 13:20:06 GMT

But at an given point of time, only one dimension will be active... so technically you can sort by y dimension.... can you share a selection where the sort isn't working for you?

Re: Multiple dimensions in bar chart

Anonymous — Mon, 28 Aug 2017 13:27:30 GMT

Sunny,

Please see this qvw. Sorting is not working for me.

Re: Multiple dimensions in bar chart

sunny_talwar — Mon, 28 Aug 2017 13:43:07 GMT

Try now

Re: Multiple dimensions in bar chart

Anonymous — Mon, 28 Aug 2017 13:56:41 GMT

Thanks Sunny, this is what I expect. Can I use this calculated dimension in a variable?

Re: Multiple dimensions in bar chart

sunny_talwar — Mon, 28 Aug 2017 13:57:53 GMT

I guess so...

Re: Multiple dimensions in bar chart

Anonymous — Mon, 28 Aug 2017 13:58:42 GMT

Thank you so much Sunny.