Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

MTD Sales

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

9 Replies
Highlighted
Creator III
Creator III

Hi Naveen

plz attach your qvw file

Highlighted
MVP
MVP

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

Why you are using -10 and -8?

Highlighted
Contributor
Contributor

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

Highlighted
MVP
MVP

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?

Highlighted
Contributor
Contributor

Depends on Today's Date

Highlighted
MVP
MVP

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.

Highlighted
Contributor
Contributor

Sorry Expert,

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

Highlighted
MVP
MVP

Use this

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

Highlighted
Contributor III
Contributor III

Hi,

Use this

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




Regards

Ruchita