Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
arneagren
Contributor
Contributor

Previous period in a economic report

Hi,

I am creating a economical report based on that the user choose a unique period, for examle 2016-10.

Summarization for current period an also YTD is ok, but how can I manage to show "Previous period" ?

YTD = Sum ({$<[Calendar Month] ={"<=$(=MAX([Calendar Month]))"}>}[Recorded amount])

why is not

Previous month = Sum ({$<[Calendar Month] ={"=$(=ONLY([Calendar Month])-1)"}>}[Recorded amount])

working ? "=$(=ONLY([Calendar Month])-1)" gives me the correct month.

Best regards

Arne

0 Replies