topic Re: two alternate states for one expression in QlikView

two alternate states for one expression

Mon, 23 Nov 2015 16:55:51 GMT

Hi guys,

i trying to achieve following task:

I know the feature alternate states and I can build a solution with two expressions and two alternates states.

But what i want is following:

I only want to have one Expression but with two alternate states.

KPI	ID1	ID2
Requests	10	20

I want a pivot table with one expression and one dimension

dimension: ID

expression: SUM(Requests)

So, now i want to have two TimeRange Filters, lets say TimeRange1 and TimeRange2

TimeRange1 should only influence ID1 and TimeRange2 should only influence ID2.

My question: Is that possible in Qlikview?

Regards

steve

Re: two alternate states for one expression

t_chetirbok — Mon, 23 Nov 2015 17:51:11 GMT

Hello!

Alternate state can influence only expressions or calculated dimensions.

And if you have two alternate states, you should have two expresiions.

Re: two alternate states for one expression

Anonymous — Mon, 23 Nov 2015 17:58:49 GMT

Yup, put your required State in the expression.

SUM( {YourState} Requests)

Re: two alternate states for one expression

Tue, 24 Nov 2015 08:06:44 GMT

Hey, thank you for your responses,

if I would do so, the state would influence both ID1 and ID2. What I need is, two filters with TimeRange, one influences the Value for ID1 and the other one influences ID2

Re: two alternate states for one expression

Wed, 11 May 2016 06:18:52 GMT

Hi Bill,

How do you do that with multiple conditions within your formula?

As an example: Avg({<[Exam Status]={'Completed'},[Exam Type]={'XR'}>}[TAT])