Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create drill down dimension
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.