Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Matching data from 2 tables in an expression

Good morning, I am trying to write an expression that colours a field in a table if 2 sets of data match :-

=if(sum(Cleared_Paid)>=sum(Amt_Latest_Default_Notice),RGB(0,0,255),RGB(190,0,0))

This expression works for the most part but doesnt always work for reasons unknown.

Can anyone help with a better idea?

Paul.

4 Replies
Not applicable

Re: Matching data from 2 tables in an expression

you mean doesnt work with the field with null value?

Not applicable

Re: Matching data from 2 tables in an expression

No, it just randomly works with some figures and not others even if they are identical.

Not applicable

Re: Matching data from 2 tables in an expression

you need to post sample file

MVP
MVP

Re: Matching data from 2 tables in an expression

Hi

Are both fields associated in the same way with the dimensions in your chart? Have you tested the two sum expressions in the chart?

If you post a sample and/or screen shot, it would help to diagnose the problem.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser