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 in a calculated dimention

Hi

I have used alternate states in two charts one set to a start field the other to and end field.(the field they use is from the my calendar YEARWEEK i.e 201701)

The charts both show the count of customers that fit a combination of two status against the dates chosen by alternate state start and alternate state end.

My data contains fields StartStatus, and EndStatus, these are linked to the field YEARWEEK in the calendar through an interval match in the load script.

This is the part I need a little help with please: I want to show in the 3rd chart, the changes in status from start (Alternate State Start) and end (Alternate State End) points

I have an IF statement for each status i.e:

IF(StartStatus=EndStatus,'1.SameStatus',

IF(EndStatus='status1A',

IF(StartStatus = 'status1B','2.StatusUp',

IF(StartStatus = 'status1C','2.StatusUp',

IF(StartStatus='status1D,'2.StatusUp',

IF(StartStatus='status1E','2.StatusUp','3.StatusDown')))),'3.StatusDown'))

The expression =Count(distinct ID)

 

How do I amend the calculated dimention to select the start status to pick up the relationship to Alternative State Start, and the EndStatus to Alternative State End?

 

I've not used Alternate States before and athough i've read through the manual, i've not seen an example where it's used in a calculated dimention, so currently a little stuck.

 

Any pointers would be most appreciated - thanks in advance

5 Replies
sunny_talwar

Would you be able to share a sample to check this out?

Not applicable
Author

HI Sunny, i'm not sure how to create a sample.

sunny_talwar

You can either mock up data which mimics your actual data or you can look here:

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

sunny_talwar

Did you get the solution you were looking for or no?

Not applicable
Author

No not quite. Thank you for your time though

Heather Montgomery