topic Re: Set Analysis in QlikView

Set Analysis

Tue, 22 Dec 2015 15:02:48 GMT

Hi all

How to write this is set Analysis

=if(num(floor(Today()))=Num(Floor(AssignmentStart)),Sum(Qty),0)

Thanks

MK_QSL — Tue, 22 Dec 2015 15:08:34 GMT

What is your dimension?

Tue, 22 Dec 2015 15:09:10 GMT

Order ID

MK_QSL — Tue, 22 Dec 2015 15:10:26 GMT

SUM({<Order ID = {"=Num(Floor(Today())) = Num(Floor(AssignmentStart))"} >}Qty)

Peter_Cammaert — Tue, 22 Dec 2015 15:27:47 GMT

Or this one. Maybe a bit easier to decypher. IMHO function InDay() is underrated...

=SUM({<Order ID = {"=InDay(AssignmentStart, Today(), 0)"}>} Qty)

miguelbraga — Tue, 22 Dec 2015 16:48:17 GMT

Make a field like this:

if(num(floor(Today()))=Num(Floor(AssignmentStart)),'1','0') as Flag

Then make a set analysis like this:

=sum({$<Flag = {'1'}>} Qty)

Simple as this

Regards,

effinty2112 — Wed, 23 Dec 2015 20:16:56 GMT

What about:

=sum(-Qty*inday(AssignmentStart,Today(),0))