Qlik Sense-Expression editor...comparing data in rows and adding in column

[QlikChick]

Good evening! I have spent the better part of my day trying to solve for this, and reading community help. Finally decided to post to get help. 🙂 

The below first three columns are from the table I have:

Client	SnapshotDate	Health	Weekly Change?
18765	3/16/2020	Poor	Yes
18765	3/9/2020	Excellent	No
18765	3/2/2020	Excellent
16547	3/16/2020	Fair	Yes
16547	3/9/2020	Excellent	No
16547	3/2/2020	Excellent	Yes
16547	2/24/2020	Poor

The last column is what I'm trying to solve for  in the expression editor. My data load editor contains some fairly complex items (creating a QVD and recalling all data to create history). I prefer not to add additional items there...

Thanks in advance!

Jenny

[Vegar · Accepted solution]

You can try solving it by using the above statement in a chart. See attached qvw. 

Expression: if(Client = above(total Client),if(Health=above( total Health), 'No','Yes'),null()) 

[QlikChick]

Thanks Vegar! I thought it didn't work at first, but must've been something I was doing wrong. I attempted again and worked perfectly. 🙂

Jenny

[Vegar]

@QlikChick  thats great!

I did get the notification from your previous comment, but assumed your where on the right track as you deleted it.

BR
Vegar