Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner
Partner

If field A = Field B then give me Field C

Hi all,

I am struggling to get something working in a chart. 

Basically i have data like the following..

So what i am trying to do is get the name associated to the ReadingDate that matches the DueDate, so in this case i would want to return name C.

Can anyone help please? Sample attached

ReadingDateDueDateName
01/01/201810/08/2018A
02/03/201810/08/2018A
10/08/201810/08/2018C
12/08/201810/08/2018B
15/09/201810/08/2018B
05/10/201810/08/2018

D

2 Solutions

Accepted Solutions
m_woolf
Master II
Master II

sunny_talwar

Try this

Concat(DISTINCT if(ReadingDate=DueDate,Name), ', ')

View solution in original post

5 Replies
m_woolf
Master II
Master II

sunny_talwar

Try this

Concat(DISTINCT if(ReadingDate=DueDate,Name), ', ')

View solution in original post

hopkinsc
Partner
Partner
Author

Hi Sunny,

I need to make a change to this but i can't seem to get it to work. 

What i need is to compare the ReadingDate to the max DueDate.

I have tried wrapping max() around the DueDate but it doesn't seem to work. 

Any suggestions?

New sample attached. 

 

sunny_talwar

May be this

Concat(DISTINCT Aggr(If(ReadingDate = Max(TOTAL <Customer>  DueDate), Name), Customer, ReadingDate), ', ')
Masi_Sahargahi
Contributor III
Contributor III

Hi

How about handling it in scrip(as I did in attached sample)?