Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
danielco
Not applicable

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
xufei123
Not applicable

Re: Show chart with Current Month over Previous Month Order Volume

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

danielco
Not applicable

Re: Show chart with Current Month over Previous Month Order Volume

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!