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: 
max_potass
Creator
Creator

Refer to previous value of an Dimension

Hello everyone,

I am trying to figure out a way, how i can achive a fully dynamic version of following:

I have a Bar chart which displays the differenc of dates. My expression is as follows:

(

SUM(If(Not IsNull(KAM_Status_Change_Date_1) AND Not IsNull(KAM_Status_Change_Date_2),KAM_Status_Change_Date_2))

-SUM(If(Not IsNull(KAM_Status_Change_Date_1) AND Not IsNull(KAM_Status_Change_Date_2),KAM_Status_Change_Date_1))

)

/Count(If(Not IsNull(KAM_Status_Change_Date_2),KAM_Status_Change_Date_2))

I have to do this for each Status there is, so I have 1 expressions and no dimension at all.

I was wondering, if there is a way, to do this with just one expression and 1 dimension.

I already came up with a solution during load, but this takes quite a while, as I need to loop a good bit... So maybe there is another way.

Best regards

Max

2 Replies
sunny_talwar

May be a synthetic dimension with Pick(Match(...)) in the expression?

max_potass
Creator
Creator
Author

Hi Sunny,

thank you for the response. By now, I just changed my datamodel (The *_1,*_2 Dimension I shrinked to one and have the number in a different Dimesnion.), which achieved what i wanted.

Have a nice day.