This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
View solution in original post
Concat(DISTINCT if(ReadingDate=DueDate,Name), ', ')
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.
New sample attached.
May be this
Concat(DISTINCT Aggr(If(ReadingDate = Max(TOTAL <Customer> DueDate), Name), Customer, ReadingDate), ', ')
How about handling it in scrip(as I did in attached sample)?