Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

Previous month from selected month

Good day!

Help please with my task)

How to calculate sales with month, which is previous from selected month?

some like:

sum({<Month=....>}Sales)

Thanks

1 Reply
hrlinder
Honored Contributor

Re: Previous month from selected month

Depends on your data model

try sum({Month={$(=month(addmonths(yourdate,-1))}...

or sum({Month={$(=Month-1)}--- if Month is numeric

Community Browser