Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

two alternate states for one expression

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.

KPIID1ID2
Requests1020

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

4 Replies
t_chetirbok
Valued Contributor

Re: two alternate states for one expression

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

Yup, put your required State in the expression.

    SUM( {YourState} Requests)

Not applicable

Re: two alternate states for one expression

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

Not applicable

Re: two alternate states for one expression

Hi Bill,

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

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