topic QlikView 11 - Displaying multiple dimensions and total with alternate states in QlikView

QlikView 11 - Displaying multiple dimensions and total with alternate states

Fri, 01 May 2015 13:56:25 GMT

Hi all -

I'm working on a longitudinal line chart --- dimensions are year and school, and expression is total square footage, and we have 12 values of school that we are looking at over time. That works fine as a regular line chart. In addition, we want to see a 13th line of the average square footage of all the schools, still charted over the range of years in the X axis. User should be able to select individual combinations of schools at will, but still keep present the line with the overall average. I've been experimenting with both set analysis and alternate states to accomplish this, but can't figure out a way to display the specific schools the users selects (which could be as few as 1 and as many as 12) individually, rather than grouping them (as in the Financial Analysis demo app). Using reference points and trend lines doesn't seem to help either.

I feel like I'm missing something really obvious, and would appreciate any pointers on how to go about this.

Thanks,

Amy Miller

Re: QlikView 11 - Displaying multiple dimensions and total with alternate states

Gysbert_Wassenaar — Fri, 01 May 2015 14:04:09 GMT

Can you post a qlikview document that demonstrates the problem?

Re: QlikView 11 - Displaying multiple dimensions and total with alternate states

stigchel — Fri, 01 May 2015 15:03:05 GMT

If I understand you correctly, the problem is that with multiple dimensions, you can't have multiple expressions and still display the 12 schools and 1 total.

In the attached example I have added a total for the School dimension in the dimension limit tab of the line chart properties. As an expression:

if(Dimensionality()=1,

Avg({<School>} Total <Year> Footage),

Sum(Footage)

)

Where the dimensionality is used for a different calculation for the total which disregards the school selections

If this is not what you mean, then please post a sample qvw

Re: QlikView 11 - Displaying multiple dimensions and total with alternate states

Fri, 01 May 2015 15:42:52 GMT

Thanks so much, Piet - I hadn't thought of dimension limits at all, but it looks like this might help. I'll experiment a bit more next week.

Thanks again.