topic Re: showing six month sales in QlikView

showing six month sales

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Greetings

is there any way to show last six month sales with out using mtd and rolling month sales

Regards

Manu

Re: showing six month sales

adityaakshaya — Thu, 03 May 2018 20:42:39 GMT

Hi Manu,

You can create a variable to calculate the last sixth month and make first date as datevalue and use that variable in set analysis. something like below

vLastSixthMonthDate = Month(Today())-6

Sum({<Date = {">=$(vLastSixthMonthDate)"}>}Sales)

Hope this helps you.

Regards,

Akshaya

Re: showing six month sales

duncanblaine — Fri, 04 May 2018 02:22:09 GMT

Hi Manu
Akshaya's solution is a good one.
Another way you can do it, if you are trying to build a chart and don't want to include variables, is to use Dimension Limits.
To do this you'll need a chart Dimension which is your distinct Months ie 'MonthYear' (format 'DD-YYYY')

On Dimension Limits tab you need to

Select your MonthYear dimension
Check Restrict which values are displayed using the first expression
Show only First 6
Uncheck Show Others

On Sort tab, you need to

Sort by MonthYear, Numeric descending
Remove all sorting on your expression eg Sum(Sales)

Hope this helps.