2 Replies Latest reply: Mar 3, 2017 12:06 PM by Dan Coen

Show chart with Current Month over Previous Month Order Volume

Dan Coen Mar 2, 2017 2:50 PM

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!

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

Fei Xu Mar 2, 2017 4:07 PM (in response to Dan Coen)

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

Actions
- Re: Show chart with Current Month over Previous Month Order Volume
  
  Dan Coen Mar 3, 2017 12:06 PM (in response to Fei Xu )
  
  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!
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post