Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rcandeo
Contributor II

How to make a date selection using Qlik View Connector for SAP?

i am using Qlik View Connector for SAP and in my selection I need to use a date field, but it doesn't work.

Anybody can help me to find out how is the real format to make a selection within a date field?

I am trying like this:

SQL Select VBELN, AEDAT from VBAP

WHERE AEDAT = '07/09/2010';



1 Solution

Accepted Solutions
rcandeo
Contributor II

How to make a date selection using Qlik View Connector for SAP?

I finally found a simple way:

SQL Select * from VBAP WHERE AEDAT = '20100907';



4 Replies
Not applicable

How to make a date selection using Qlik View Connector for SAP?

Hi robson,

You can define a Variable at the Starting in Main like this:

Let vMinDate = num('01.01.2009')

and then

write a load like this


VBAP:
SQL Select VBELN,
AEDAT
.....
.....
From VBAP
where num(AEDAT) >= $(vMinDate)
;



Hope this helps.

Regards
Sravan

rcandeo
Contributor II

How to make a date selection using Qlik View Connector for SAP?

Unfortunatelly not worked.

It gave to me an SQL error:

Let vMinDate = num('01.01.2010');

SQL Select * from VBAP WHERE num(AEDAT) >= $(vMinDate);

rcandeo
Contributor II

How to make a date selection using Qlik View Connector for SAP?

I finally found a simple way:

SQL Select * from VBAP WHERE AEDAT = '20100907';



suniljain
Honored Contributor

How to make a date selection using Qlik View Connector for SAP?

Dear Robson,

I am Using same format like '20100907'. And it Works Fine

Community Browser