Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QlkSense newbie question. I have a chart that shows total orders per month. I want one bar chart to always show current month order volumes over previous month order volumes.
The dimensions are
[Fiscal - Period Name]
the measures are:
Count([Order - Order Number])
Thanks!
Count({<YourDateID={">=$(=monthstart(today(),-1))"}>} [Order - Order Number])
Thanks Fei!
What if I just wanted to have a dimension that only shows current month and previous month? the dimension is [Fiscal - Period Name].
I want to use set analysis to create a variable that always current fiscal month and previous fiscal month.
Thanks in advance!