topic Monthly Comparison Calculation in QlikView

Monthly Comparison Calculation

katetsan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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

Thanks.

shraddha_g — Tue, 12 Sep 2017 04:53:39 GMT

If possible provide some more details about data.

Share sample data or Sample app

Anil_Babu_Samineni — Tue, 12 Sep 2017 04:54:54 GMT

Yes

its_anandrjs — Tue, 12 Sep 2017 04:59:54 GMT

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 — Tue, 12 Sep 2017 05:11:22 GMT

Hi Kate,

Combo Chart

Dimension Month

Expression (Line) : Sum(Sale)

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

Regards,

Antonio

qlik4asif — Tue, 12 Sep 2017 05:12:17 GMT

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 — Tue, 12 Sep 2017 05:39:50 GMT

Hi Antonio,

Very useful. Thanks a lot!