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

Displaying Multiple Dimensions with the Same Expression in the Same Chart

Thu, 08 Oct 2015 17:42:28 GMT

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:

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

Qrishna — Thu, 08 Oct 2015 17:54:07 GMT

could you please post some sample data or a qvw?

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

Thu, 08 Oct 2015 18:38:07 GMT

Attached sample file to original post

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

Kushal_Chawda — Thu, 08 Oct 2015 18:54:51 GMT

Please see the attached

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

Thu, 08 Oct 2015 18:58:58 GMT

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.

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

Thu, 08 Oct 2015 19:26:05 GMT

Please look at the attached.

Thanks

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

Kushal_Chawda — Thu, 08 Oct 2015 19:45:27 GMT

You can do it from script with Field event trigger

Please find the attached

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

Thu, 08 Oct 2015 20:10:48 GMT

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?

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

Thu, 08 Oct 2015 20:13:47 GMT

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

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

Thu, 08 Oct 2015 20:41:32 GMT

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

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

Thu, 08 Oct 2015 21:20:17 GMT

In my real world use case I have 20 metrics. I will have 5 buttons that select a subset of those 20.

For the example: Button1 = All Dims, Button2 = Dim1 and Dim2, Button 3 = Dim 3 only

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

Fri, 09 Oct 2015 17:28:48 GMT

You can use Bookmarks for that

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

Fri, 09 Oct 2015 17:41:42 GMT

I don't follow. Your example only showed one dimension at a time, but I need to be able to see multiples at the same time.