Date quires

[sculptorlv]

I deleted my previous topic - SQL quires where correct.

My real problem is with qlikview query :

LOAD

FA_Location_Subcode,

SUM(Bought_Quantity) AS Bought_Last_Month

RESIDENT DATASOURCE_SALES

WHERE

MONTHNAME(Bought_Date) = MONTHNAME(Today())-1

GROUP BY

FA_Location_Subcode;

As a result I got ZERO data. I think because of this restriction:

MONTHNAME(Bought_Date) = MONTHNAME(Today())-1

I need all data from December 2017 ...

How can I correct my formulas?

I hope for your help!

[tresesco]

May be this?

MONTHNAME(Bought_Date) = MONTHNAME(Today() ,-1)

[sculptorlv]

sintax error

[sculptorlv]

I have made some tests:

The code is:

And the result is:

So, How can I correctly get -1 Month in order to compare second and fourth columns?

[PrashantSangle]

search in help menu

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/da...

What are you trying to achieve??

Regards,

[sculptorlv]

I need to take all data with date of previous month

[tresesco]

The syntax error must be somewhere else. Could you post the screenshot of the error and the script snippet?

[mdmukramali · Accepted solution]

Hi,

Same Data You want to take it for the Last Month?

If Yes then can you try something like this:

=MonthName(MonthStart(Today())-1)

[sculptorlv]

OMG .. so simple, I feel stupid! Thank you very much!