topic Re: MTD Sales in QlikView

MTD Sales

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

Hello All,

am trying to find sales of MTD but it showing 0 Please any one check that expression

=sum({<OrderDate={">=$(=MonthStart(today(),-10))<=$(=AddMonths(today(),-8))"}>}sales)

this expression is showing proper dates i need (01/06/2017 to 07/08/2017) Sales...

Please

thank you

Re: MTD Sales

woshua5550 — Sun, 08 Apr 2018 08:18:39 GMT

Hi Naveen

plz attach your qvw file

Re: MTD Sales

MK_QSL — Sun, 08 Apr 2018 10:24:08 GMT

What exactly you are trying to achieve? This expression not looks like MTD Sales.

Why you are using -10 and -8?

Re: MTD Sales

potti222 — Sun, 08 Apr 2018 11:32:15 GMT

acually am new to qlikview....

i want data from 01/06/2017 to 07/08/2017 sales how can i write the expression..

Thank You

Re: MTD Sales

MK_QSL — Sun, 08 Apr 2018 12:09:31 GMT

No worries. You are at right place to get support.

You need to provide Logic first..

Everytime you need data between these dates or it depends on today's date?

Re: MTD Sales

potti222 — Sun, 08 Apr 2018 12:12:09 GMT

Depends on Today's Date

Re: MTD Sales

MK_QSL — Sun, 08 Apr 2018 12:35:42 GMT

So what is the logic?

6 months before today's date...? or 10 months before today' s date?

Instead of replying with one line, please provide full information on your requirements.

We will help you to achieve your output.

Re: MTD Sales

potti222 — Sun, 08 Apr 2018 13:27:39 GMT

Sorry Expert,

Just am Practiceing qlikview....Depends on today's date i want to calculate the (01/06/2017 to 07/08/2017) sales..

Re: MTD Sales

MK_QSL — Sun, 08 Apr 2018 13:54:26 GMT

Use this

SUM({<OrderDate = {">=$(=MonthStart(Today(),-10))<=$(=AddMonths(Today()-1,-8))"}>}Sales)

Re: MTD Sales

Anonymous — Mon, 09 Apr 2018 11:35:16 GMT

Hi,

Use this

=SUM({<OrderDate = {">=$(=MonthStart(AddMonths(Today(),-10)))<=$(=AddMonths(Today()-1,-8))"}>}Sales)

Regards

Ruchita