Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

MTD and YTD help on KPI object

Hi,

I am trying to created a Dashboard for my sales performance and I would like to have 2 KPI objects: MTD and YTD

Sum({1<"MONTH"={"$(=Month(Today()))"}>}ORDERS)

Sum({1<"YEAR"={"$(=YEAR(Today()))"}>}ORDERS)

This is not working, any clues on what I am doing wrong?

Renata

Tags (1)
2 Replies
sunny_talwar
Not applicable

Re: MTD and YTD help on KPI object

I don't see any issue except that MTD will include the whole Month of Feb and YTD will include Whole Year 2017. Is that what you want?

kaushik_solanki
Not applicable

Re: MTD and YTD help on KPI object

Try this.

Sum({1<MONTH={"$(=Month(Today()))"}>}ORDERS)

Sum({1<YEAR={"$(=YEAR(Today()))"}>}ORDERS)

Removed the double Quotes from field name.

Regards,

Kaushik Solanki