topic Re: Calculation using date in QlikView

Calculation using date

Wed, 18 Mar 2015 14:09:34 GMT

Hi Team,

I need to calculate sum of quantity for Maximum date -7.

For more reference you can use the two attachment.

Please guide.

Thanks in advance

Priyanka Pandey

buzzy996 — Wed, 18 Mar 2015 14:12:28 GMT

means "for Maximum date -7"?pls.

its_anandrjs — Wed, 18 Mar 2015 14:15:38 GMT

Hi,

Try to use SET analysis expression

Sum({<ShipDate = {'$(=Date(Max(ShipDate)-7))'}>} Quantity)

Also check the attached solution

Regards,

Anand

Wed, 18 Mar 2015 14:16:28 GMT

yes, I need to calculate

=Sum({<ShipDate={$(#MaxDate)}>}Quantity)

Where MaxDate =Date(Max(ShipDate)-7) but its throwing an error.

Wed, 18 Mar 2015 14:19:21 GMT

Thanks Anand.

It was a great help from you

Regards

Priyanka Pandey