topic Re: Date quires in QlikView

Date quires

sculptorlv — Thu, 04 Jan 2018 10:47:48 GMT

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!

Re: Date quires

tresB — Thu, 04 Jan 2018 10:50:30 GMT

May be this?

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

Re: Date quires

sculptorlv — Thu, 04 Jan 2018 11:04:32 GMT

sintax error

Re: Date quires

sculptorlv — Thu, 04 Jan 2018 11:12:36 GMT

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?

Re: Date quires

PrashantSangle — Thu, 04 Jan 2018 11:18:41 GMT

search in help menu

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/date-time-functions.htm

What are you trying to achieve??

Regards,

Re: Date quires

sculptorlv — Thu, 04 Jan 2018 11:31:29 GMT

I need to take all data with date of previous month

Re: Date quires

tresB — Thu, 04 Jan 2018 11:35:32 GMT

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

Re: Date quires

mdmukramali — Thu, 04 Jan 2018 11:43:59 GMT

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)

Re: Date quires

sculptorlv — Thu, 04 Jan 2018 11:49:12 GMT

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