topic Re: Static Scale for two (alternate state) charts in QlikView

Static Scale for two (alternate state) charts

Thu, 24 Jan 2013 10:23:41 GMT

I have two charts with two different alternate states and two sets of list boxes driving the selections for these charts.

When I make selections with STATE A chart the chart scale change dynamically which is great.

My issue is that when I make changes to the list boxes for State B - the state B chart also changes dynamically which can be misleading?

Can I rebase the State B chart axis to be equally to what it is for State A or vice verse?

Thanks very much for your help

(have tried to show a basic example below of my set up)

List boxes that drive List boxes that drive

State A selections State B selections

STATE A Chart STATE B CHART

Re: Static Scale for two (alternate state) charts

sbaldwin — Thu, 24 Jan 2013 10:50:41 GMT

Hi, have you tried using a bit of set analysis on the charts using the two states but making the"other" state an invisable line that way your scales will remain the same, i have attached an example

Re: Static Scale for two (alternate state) charts

Mon, 28 Jan 2013 13:40:25 GMT

100%

Thanks so much for taking the time to help me on this!

Re: Static Scale for two (alternate state) charts

Mon, 28 Jan 2013 13:46:01 GMT

I have another Question that I would be grateful if you answered.

I have a pivot with a list of clients and stats beside them.

I want to permanently exclude a group of people (Tier A) from the pivot without having to make selections in the Tier list box.

What is the best way to go about this?

Client Tier $

Client A Tier A xx

Client B Tier A xx

Client C Tier B xx

Client D Tier B xx

Client E Tier C xx