Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Calculation using date

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

Tags (3)
1 Solution

Accepted Solutions

Re: Calculation using date

Hi,

Try to use SET analysis expression

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

Also check the attached solution

Regards,

Anand

View solution in original post

4 Replies
buzzy996
Honored Contributor II

Re: Calculation using date

means "for Maximum date -7"?pls.

Re: Calculation using date

Hi,

Try to use SET analysis expression

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

Also check the attached solution

Regards,

Anand

View solution in original post

Not applicable

Re: Calculation using date

yes, I need to calculate

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

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

Not applicable

Re: Calculation using date

Thanks Anand.

It was a great help from you

Regards

Priyanka Pandey