Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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

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:

ClientSnapshotDateHealthWeekly Change?
187653/16/2020PoorYes
187653/9/2020ExcellentNo
187653/2/2020Excellent 
165473/16/2020FairYes
165473/9/2020ExcellentNo
165473/2/2020ExcellentYes
165472/24/2020Poor 

 

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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

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

image.png

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Highlighted
Partner
Partner

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

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

image.png

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Contributor II
Contributor II

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

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

Highlighted
Partner
Partner

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

@JStal  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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes