topic Re: Concat dates with condition in QlikView

Concat dates with condition

Anonymous — Tue, 09 Sep 2014 06:20:56 GMT

Good day!

In attached model i calculate in one pivot table sum(quantity by Spoints), in second - concat dates where sum(quantity)>30

But result is wrong.

Expected result:

Spoint1: 23-09-2014, 25-09-2014

Spoint2: 22-09-2014, 23-09-2014, 24-09-2014, 25-09-2014

Thanks!

senpradip007 — Tue, 09 Sep 2014 06:45:03 GMT

Try like

=concat({<Quantity={">30"}>}DISTINCT Date,', ')

maxgro — Tue, 09 Sep 2014 06:45:10 GMT

=concat( if(aggr(sum(Quantity),Spoint,Date)>30, Date), ', ')

aveeeeeee7en — Tue, 09 Sep 2014 06:46:56 GMT

Try this expression:

=concat ( IF( aggr ( (sum(Quantity)),Spoint,Date)>30,Date),',')

Also, see the Attachment.

Hope that helps.

Regards

Aviral Nag

jonathandienst — Tue, 09 Sep 2014 06:53:31 GMT

Concat(Aggr(If(Sum(Quantity) > 30, Date), Date, Spoint), ', ')

HTH

Jonathan