Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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