Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I wanted to show line Chart for Previous month and current month for dimension :Month-> Day
Expression for current month
=sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))}>} Sales)
Current Month works fine
Expression for Previous month
=sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))},MonthID={$(=max(MonthID)-1)}>} Sales)
It Showing Wrong output
Can anyone help me?
If you have Month as Dimension, then you have to keep in mind that in QlikView Set Analysis, Set Expression will evaluate once only per chart..
Don't you think, Current month should like this?
sum({<type={'Order'},FiscalYear={"$(=max(FiscalYear))"},MonthID={"$(=max(MonthID))"}>} Sales)
for previous try this
=above(sum({<type={'Order'},FiscalYear={"$(=max(FiscalYear))"}>} Sales),0,rowno())
Thank you Kushal Chawda
Sorry it didn't work
Would you be able to share a sample?
It may be look like it
Better u can use "above" function to get the data's of previous month.
Hi,
Use above function : (above(sum({<type={'Order'},FiscalYear={"$(=max(FiscalYear))"}>} Sales))
and set previous year max month in the variable then use that variable in null values in the column.
Hi Scotly,
In our master calendar, make use of inMonth() and InMonthToDate() function to set flags and make use of these flags in set analysis.
This will even improve the performance.
Thanks,
Sangram.