Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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)?