On combo chart, display both profit for the month and cumulative avg profit since yearstart

[Ashley33]

Hello Dears,

Please find attached the excel data. Please note that i will only have column A, B and C in my data. The columns D and E i have manually calculated to express the requirement but in the final excel, i will only have columns A, B and C.

That is, I will have to calculate the profit as an expression in the bar chart in qliksense.

Requirment is to display On combo chart for each dimension of Month, display profit for the month and cumulative avg profit since yearstart

For example if year is 2018 and month is 03, then display in a combo chart the profit of 03/2019 as bar chart and the average profit since bginning of year as avg(sum of profit for month 01, 02 and 03 of year 2018)

For example if year is 2019 and month is 05, then display in a combo chart the profit of 05/2019 as bar chart and the average profit since bginning of year as avg(sum of profit for month 01, 02, 03, 04, 05 of year 2019  (but not 2018)). That is only for the selected year

something like this: where series 2 = proft and series 3 = average profit since beginning of year

Thanks for your help 🙂

[mayuringale25 · Accepted solution]

Hi @Ashley33 

Please refer attached qvf

[Ashley33]

Thank you 🙂

Looks great and working well. Wish you a very great beautiful day! 🙂 🙂 🙂

[mayuringale25]

Thank you @Ashley33 have a great day.