Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Displaying Multiple Dimensions with the Same Expression in the Same Chart

I am trying to create a single chart, if possible, that will include the % of the population that has a number of characteristics. This could easily be achieved using set analysis in each expression, however, I would like each bar to be selectable so the user can filter the population based on the criteria for that bar. In order to do so, I was using a variable calculated dimension (EX:if(aggr(sum({<CurrentFlag={1}>} Dollars),Patient_ID)=0,'Zero Spend')) and then a standard expression (EX: sum(Patient_Counter)/sum(Total Patient_Counter)).

I have 20 of these different calculations, that I plan to show and hide using buttons, but I would like these to be on the same chart so I have a consistent axis and scale from dimension to dimension. I can't think of a way to accomplish this; I tried a container which makes them appear to be one graph, however, the axes don't align and scales would have to be hard coded. Any suggestions?

I'd like it to look like this:

Capture.PNG

12 Replies
krishna_2644
Valued Contributor III

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

could you please post some sample data or a qvw?

Not applicable

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

Attached sample file to original post

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

Please see the attached

Not applicable

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

That seems like a more complex way of just using no dimension and just using a different expression for each metric. Because the bars are not selectable. I want the user to be able to highlight the particular metric and select the patients that meet the criteria. My original charts accomplish that, but in your example they are not selectable.

Not applicable

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

Please look at the attached.

Thanks

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

You can do it from script with Field event trigger

Please find the attached

Not applicable

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

My actual data model is much more complex than this and will have calculations that span multiple tables, so I don't think this option is doable.

Attrib1 may be a calculation from tables 1 and 2

Attrib2 may be from a 3rd table

Attrib4 may be a calculation from tables 2 and 4

So I don't think that works, right?

Not applicable

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

I want to be able to view all dimensions at the same.

Not applicable

Re: Displaying Multiple Dimensions with the Same Expression in the Same Chart

You have mentioned that you want to show and hide the Dim using Buttons right?

Community Browser