two alternate states for one expression

[#1]

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

[t_chetirbok]

Hello!

Alternate state can influence only expressions or calculated dimensions.

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

[Anonymous]

Yup, put your required State in the expression.

    SUM( {YourState} Requests)

[#4]

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

[#5]

Hi Bill,

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

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