Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Last Months Activity

Hi all,

I'm trying to write a formula to just bring through last months activity, ive tried using the formula but with no joy.

Anyone have any ideas as to how I could alter this to bring through just last months data?

·         =SUM({<Metric_Code “RTT9”={">=$(=MonthStart(Today(),-1)) <=$(=MonthEnd(Today(),-1))"}>} Metric_Value)

mMany thanks in advance,

Nick

1 Reply
awhitfield
Esteemed Contributor

Re: Last Months Activity

Hi Nick,

check this one out!

https://community.qlik.com/docs/DOC-4313

Andy

Community Browser