Monthly Comparison Calculation

[katetsan]

Hi Experts,

Is there any way to calculate the monthly growth as below bar chart in Expression?

Thanks.

[shraddha_g]

If possible provide some more details about data.

Share sample data or Sample app

[Anil_Babu_Samineni]

Yes

[its_anandrjs]

The chart you shown as sample is combo chart with Bar chart and line chart you can do this with one Dimension and two expression

[antoniotiman · Accepted solution]

Hi Kate,

Combo Chart

Dimension Month

Expression (Line)  : Sum(Sale)

Expression (Bar)  :  Sum(Sale) - Above(Sale)

Regards,

Antonio

[qlik4asif]

Take combo chart ,add 1 dim  as month and 2 measures as Sales and MoM.....Keep sales in line chart

Then you can see growth of sales across month wise

[katetsan]

Hi Antonio,

Very useful. Thanks a lot!