Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

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

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