# New to Qlik Sense

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for
Did you mean:
Contributor III

## How to get Month Values using set analysis

Hi All,

By using the below formula I am getting the Max value (September)

(Sum({<Month = {'\$(=Date(Max(Date#([Month],'MMMM')),'MMMM'))'}>}[Amount]))

By using the below formula I am getting the Min value (January)

(Sum({<Month = {'\$(=Date(Min(Date#([Month],'MMMM')),'MMMM'))'}>}[Amount]))

By using the below formula I am getting the Max -1 value (August)

(Sum({<Month = {'\$(=Date(Min(Date#([Month],'MMMM')),'MMMM'))'}>}[Amount]))

I am unable to get the July Value by using set analysis

I am unable to get the June value by using set analysis

and So on...

Below is the Table format:

Month      Place         Amount

February    Mexico     2000

March        USA           3000

April          Australia      4000

May         India             5000

June        India            6000

July       Mexico           7000

August    Mexico          8000

September  USA          9000

1 Solution

Accepted Solutions
Creator II

hi Varma,

June month-(Sum({<Month = {'\$(=Date(Max(Date#([Month],'MMMM'),4),'MMMM'))'}>}[Amount]))

July month- (Sum({<Month = {'\$(=Date(Max(Date#([Month],'MMMM'),3),'MMMM'))'}>}[Amount]))

Regards,

raji

4 Replies
MVP

What is your business requirement? Why do you need separate expressions for every months data?

If you need July data you can simply write expression like:

Sum({<Month={'July'}>}Amount)

Creator II

hi Varma,

June month-(Sum({<Month = {'\$(=Date(Max(Date#([Month],'MMMM'),4),'MMMM'))'}>}[Amount]))

July month- (Sum({<Month = {'\$(=Date(Max(Date#([Month],'MMMM'),3),'MMMM'))'}>}[Amount]))

Regards,

raji

Contributor III
Author

Hi

What ever you did it will help in the constant values.

Every time months will change in those scenario if I do it in dynamic that will be helpful to mu business

Contributor III
Author

Hi Raji,

Below formula is not working can you please try and let me know again

Tags
Community Browser