MTD Sales

[potti222]

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

[woshua5550]

Hi Naveen

plz attach your qvw file

[MK_QSL]

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

Why you are using -10 and -8?

[potti222]

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

[MK_QSL]

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?

[potti222]

Depends on Today's Date

[MK_QSL]

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.

[potti222]

Sorry Expert,

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

[MK_QSL]

Use this

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

[Anonymous]

Hi,

Use this

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

Regards

Ruchita