topic Re: Qlik Sense-Expression editor...comparing data in rows and adding in column in App Development

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

QlikChick — Fri, 20 Mar 2020 21:32:40 GMT

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

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

Vegar — Fri, 20 Mar 2020 23:18:28 GMT

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())

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

QlikChick — Tue, 24 Mar 2020 17:48:52 GMT

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

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

Vegar — Tue, 24 Mar 2020 19:26:22 GMT

@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