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
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
varma8998
Contributor III
Contributor III

How to calculate months value in set analysis

Hi All,

I have table like in the below format

Month         Region

July           Canada

August        New York

September  Canada

October       Australia  

November   Australia

December   India

i want to show the each and every month separately using set analysis

4 Replies
Taoufiq_Zarra

what is the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
varma8998
Contributor III
Contributor III
Author

Hi

I know how to calculate the max month and min month values by using the set analysis

how to calculate between months

martinpohl
Partner
Partner

for example:

create a chart,

month as dimension

sum({<datefield={">=$(=addmonths(monthstart(max(datefield)),-6)<=$(=monthend(max(datefield))"}, Year, Month, Monthname>} Value)

to see values from 12/01/2019 to 6/5/2020

Regards

varma8998
Contributor III
Contributor III
Author

How to see the value june August September out of 12 months