topic Show total value in a chart qliksense in App Development

Show total value in a chart qliksense

Aspiring_Developer — Wed, 09 Feb 2022 14:24:15 GMT

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

Re: Show total value in a chart qliksense

hic — Wed, 09 Feb 2022 15:41:21 GMT

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')