topic Re: convert date functions in qlikview to sql in QlikView

convert date functions in qlikview to sql

Anonymous — Thu, 15 Oct 2015 06:45:33 GMT

Hi,

I want to convert the following as where calue condition which used Qlikview function into sql and run and check it sql side.

could you please help me in converting there Qlikview function into sql

(DATE(DATE#(MID(time,1,10),'YYYY-MM-DD'))>=DATE(ADDMONTHS(TODAY(),-24))) AND (DATE(DATE#(MID(time,1,10),'YYYY-MM-DD')))<=DATE(TODAY()) .

Re: convert date functions in qlikview to sql

sujeetsingh — Thu, 15 Oct 2015 06:49:10 GMT

Tej,

First of there no need to convert the qlik i sql. Explore SQL date function.

Well what you want to achieve by this?

Re: convert date functions in qlikview to sql

vincent_ardiet — Thu, 15 Oct 2015 06:58:28 GMT

Which DB are you using? Oracle, SQL Server?

Re: convert date functions in qlikview to sql

Anonymous — Thu, 15 Oct 2015 07:00:40 GMT

@Vincent

SQL Server

Re: convert date functions in qlikview to sql

Anonymous — Thu, 15 Oct 2015 07:02:04 GMT

@sujeet

I wanted to check the exact Qlikview functions in sql and run the query in sql to get data from back end

I wanted to filter it in sql query for 2 years data like how I am filtering it in qlikview

Re: convert date functions in qlikview to sql

senpradip007 — Thu, 15 Oct 2015 07:03:16 GMT

Where do you use this condition in qlikview or sql server?

Re: convert date functions in qlikview to sql

Anonymous — Thu, 15 Oct 2015 07:05:50 GMT

I used these conditions in Qlikview and now I wanted to user the same conditions in sql

Re: convert date functions in qlikview to sql

SreeniJD — Thu, 15 Oct 2015 07:06:38 GMT

Teja -

Try this..

SELECT * FROM tableName WHERE columName BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 720 DAY)

Re: convert date functions in qlikview to sql

vincent_ardiet — Thu, 15 Oct 2015 09:36:38 GMT

Try

Cast(Floor(Cast([time] as float)) as datetime) between dateadd(MONTH,-24,getdate()) and getdate()

Regards,

Vincent

Re: convert date functions in qlikview to sql

Anonymous — Thu, 15 Oct 2015 09:49:44 GMT

Hi sreeni and Vincent,

I am getting error while I am running this

Re: convert date functions in qlikview to sql

SreeniJD — Thu, 15 Oct 2015 10:04:02 GMT

Hi Teja

Can you clarify one thing... you want to convert the SQL from Qlikview to SQL (Oralce,MySQL) and execute the same in Oracle DB?

Sreeni

Re: convert date functions in qlikview to sql

Anonymous — Thu, 15 Oct 2015 10:06:34 GMT

No I wanted to run a sql query from the Qlikview and I am connecting to the database database from Qlikview.

Re: convert date functions in qlikview to sql

settu_periasamy — Thu, 15 Oct 2015 10:13:40 GMT

Hi,

May be like this..

CONVERT(TIME,GETDATE())>=DATEADD(month,-24,CURDATE()) AND

CONVERT(TIME,GETDATE())<=CURDATE()

Re: convert date functions in qlikview to sql

vincent_ardiet — Thu, 15 Oct 2015 10:14:02 GMT

Have you tried to run my code directly on SQLServer ?