Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')