topic Alternate States - using Expressions in QlikView

Alternate States - using Expressions

Tue, 26 Nov 2013 00:13:56 GMT

Hi All,

I have a Line /Bar Chart - using the bars to show my current forecast and the line to show one from a set of previous forecasts. To allow the user to select which previous to select I set up two list boxes for ForecastVersion. I then added the following expression to enable the first state (Forecast1).

Sum({Forecast1 <Measure ={'Printer Sales'}>}Data)

I have a similar expression for Forecast2. My problem now is that I can't use any of my other Measures such as, Region, Year, Market etc.. Can anyone help me to understand how to set up my expression to allow selection of these other measures to affect my chart? I've tried setting these other measures to Inherited and Default but to no avail

Thanks

John

Re: Alternate States - using Expressions

tresB — Tue, 26 Nov 2013 04:47:23 GMT

Have a look here: Is possible to use alternate States with set analysis

Re: Alternate States - using Expressions

er_mohit — Tue, 26 Nov 2013 05:36:03 GMT

To reflect other fields on this

try this

Sum({Forecast1 <Measure ={'Printer Sales'},Region=$:: Region,Year=$:: Year,Market = $:: Market >}Data)

Re: Alternate States - using Expressions

Thu, 28 Nov 2013 15:20:27 GMT

Thanks for tha Mohit, I actuall had it right initially but forgot that I had renamed the Dimension- duh

Re: Alternate States - using Expressions

dirk_konings — Thu, 28 Nov 2013 15:22:32 GMT

or this to have all selections included for an intersection

Sum({$*[Forecast1] <Measure ={'Printer Sales'} >}Data)

Dirk