Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello!
Alternate state can influence only expressions or calculated dimensions.
And if you have two alternate states, you should have two expresiions.
Yup, put your required State in the expression.
SUM( {YourState} Requests)
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
Hi Bill,
How do you do that with multiple conditions within your formula?
As an example: Avg({<[Exam Status]={'Completed'},[Exam Type]={'XR'}>}[TAT])