Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
uko223
Contributor III
Contributor III

Show chart with Current Month over Previous Month Order Volume

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!

2 Replies
NZFei
Partner - Specialist
Partner - Specialist

Count({<YourDateID={">=$(=monthstart(today(),-1))"}>} [Order - Order Number])

uko223
Contributor III
Contributor III
Author

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!