Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

Values Show based on the month selection

Hi All,

I have a KPI is Sum(Sales),As per my requirement my KPI should show if it is in clear all position  the KPI value should show current month data.If user selected any month the value should show based on the  selected month ,if user click on clear all it should be back to current month data any help.

 

Thanks.

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum({<MonthField, MonthYearField = {"$(=MaxString(MonthYearField ))"}>}Sales)

View solution in original post

2 Replies
sunny_talwar

May be this

Sum({<MonthField, MonthYearField = {"$(=MaxString(MonthYearField ))"}>}Sales)

View solution in original post

Rohan
Creator
Creator

Hey, I think you just need a basic MTD equation.

Sum ({<Date = {">=$(=Monthstart(max(Date))) <=$(=Monthend(max(Date)))"}>} Sales).

Thanks & Regards

Rohan S. Desai.