topic Where condition for Previous Quarter data dynamically while extracting from SQL Server in QlikView

Where condition for Previous Quarter data dynamically while extracting from SQL Server

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

Hi All,

How to write condition at SQL Query to extract only Previous Quarter data (Dynamically) from SQL Server to QlikView.

Date filed format '201911'

Thanks, Nihhal.

Re: Where condition for Previous Quarter data dynamically while extracting from DB

QlikJunkie — Thu, 21 Nov 2019 16:54:11 GMT

Try if it helps....!!

SELECT * FROM
table_name
WHERE
TO_DATE( your_date_field, 'YYYYMM' )

BETWEEN trunc(add_months(SYSDATE,-3),'Q') AND trunc(add_months(SYSDATE,0),'Q') - ( 1 / ( 24 * 60 * 60 ) )

(Oracle SQl Syntax, change function syntax if you are on MS SQL Server)

Re: Where condition for Previous Quarter data dynamically while extracting from DB

nihhalmca — Fri, 22 Nov 2019 11:07:20 GMT

Thanks for response, can you share SQL Server syntax if you have idea actually i am new to it.

Re: Where condition for Previous Quarter data dynamically while extracting from DB

QlikJunkie — Fri, 22 Nov 2019 14:51:57 GMT

SQL Server...!

SELECT * FROM
"table_name"
WHERE
CONVERT(DATETIME, "your_date_field", 'YYYYMM' )
BETWEEN trunc(dateadd(month, -3, GETDATE()),'Q') AND trunc(dateadd(month, 0, GETDATE()),'Q') - ( 1 / ( 24 * 60 * 60 ) )

Re: Where condition for Previous Quarter data dynamically while extracting from SQL Server

Brett_Bleess — Wed, 04 Dec 2019 22:52:54 GMT

Nihhal, did the last post get you what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on the post to mark it and give credit to the poster as well as let the other Community Members know that it did work.

Here is something else though that you may want to consider:

https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534

That might be another way to do things.

Regards,
Brett