Show total value in a chart qliksense

[Aspiring_Developer]

Hi All,

I have below table :-

My requirement is I need to show single value of each month like below :-

Oct 2021- Total of all the values in month of oct 

Nov 2021- total of all values in the month of nov

There should be single line of record for each value . How can we group it ?

Can we do it in front end ?

Thanks in advance

[hic]

You have created a dimension using the Date() function, probably through Date(ISSUE_CLOSED_DATE,'MMM-YY') or something similar. Note that the dimension then is formatted the way you want it, but the different dates still have different values: There are still multiple values within a month.

See more on 
https://community.qlik.com/t5/Qlik-Design-Blog/Data-Types-in-QlikView/ba-p/1474977 
https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157 

Try this instead:

Date(MonthStart(ISSUE_CLOSED_DATE),'MMM-YY')