Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate States data in charts

Hi,

I would like to compare between  identical events which take place in different calendar periods, using alternate states.

The issue I have is with displaying the dates of each state as expressions in a pivot table.

For each state, I would like to show the relevat date and the total amount ordered.

I attach the document I'm working on.

Thanks in Advance!

Anne

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

21 Replies
ecolomer
Master II
Master II

Try changing Only by Max

ecolomer
Master II
Master II

p10.png

Not applicable
Author

Hi Enrique,

I need to display each date, so max and Only are not good options...

Thank you!

ecolomer
Master II
Master II

each date =  all possible dates?

Not applicable
Author

Yes...

ecolomer
Master II
Master II

Is that?

p10.png

Not applicable
Author

Getting close 🙂

Since events have the same number of dates, is it possible to locate them above each other, like i tried to do?

so this way you can calculate the difference between the periods.

(the data in my example are not perfect..)

Thank you!

ecolomer
Master II
Master II

Change your data an explain me what is the result you need

Not applicable
Author

In general, (how) is it possible to reference alternate state data as dimensions?