Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Highlighted
Creator
Creator

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.