How to get YoY, MoM growth data based on product

abc_18 — Sat, 16 Nov 2024 19:13:46 GMT

Hello,

I have two dimension fields, FY (FY18, FY19) and FMonth (Jan, Feb).

I have to show YoY and MoM data in a line chart , based on product selections.

For ex:-Initially chart, should display YOY growth data, and if users selects any Financial year, it should drill to month, and display MoM growth data, all selections include product .

I have used below formula as suggested in qlik community, but I am getting 0 values.

=Sum(qty)/Above(Sum(qty))-1

Please suggest.

Re: How to get YoY, MoM growth data based on product

UserID2626 — Mon, 27 Jan 2020 13:19:33 GMT

Create drill down dimension

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Dimensions/create-drill-down-dimension.htm

In drill down year as first and month next so that selecting year will switch to all 12 months.

if you want to show only last two months when when year is selected

=aggr(only({<Date={">=$(=Monthstart(Max(Date),-1))<=$(=Monthend(Max(Date)))"}>}[Month]),[Month])

Measure

(Sum(qty)-Above(Sum(qty)))/Above(Sum(qty)

this will display value of current vs previous in chart, if you use this formula kindly check the sorting, this will work based on sorting section only

My MOM formula is sum(Revenue)-Above(Sum(Revenue)) -just for eg used. for july 2019 it will not display because my dimension last 6 months only.

topic Re: How to get YoY, MoM growth data based on product in App Development

How to get YoY, MoM growth data based on product

Re: How to get YoY, MoM growth data based on product