Uploading of data from server into Qlikviewf rom a specific date onwards

[#1]

Hi all,

I am trying to upload a data from the server into qlikview. I am wondering if there is any ways which I can actually upload the data from a specific date onwards? For example, I have a data dated from year 2013 to year 2014, but I only want to show the data from Jan 2014 onwards when I upload the data. Can anyone advise me on this. Thank you.

[Anonymous]

Hi,

Below condition may help you to achieve that,

LOAD

......

From <TABLE>

Where Year(Date)>=Year(Today());

PS: Here "Date" is your actual date available in table.

[#3]

Hi,

Thanks for your reply. I tried input the condition but it doesn't seems to work. My expression condition is as below:

  Load

....

From <table>

where Year(as_of_date)=> Year(Today(23Jun2014));

Do you have any idea where I have gone wrong.

Thank you.

[Anonymous]

Hi,

Today function should be written only Today() not Today(23Jun2014).

Something like below,

where Year(as_of_date)=> Year(Today());

Or if you want to consider 2 days before date then below condition should work,

where Year(as_of_date)=> Year(Today()-2);

[#5]

Hi,

I had tried the above mentioned condition but it still doesn't work.

[jagan]

Hi,

From which Database server are you loading the data into qlikview?

REgards,

Jagan..

[#7]

Hi Jagan,

I am actually loading the data from the data warehouse server from my company.

Regards,

Andy

[Anonymous]

Hi,

Just to let you know, these are QlikView function/script and may not be used in SELECT statement. You may have to try like below,

LOAD

    .....

WHERE Year(as_of_date)=> Year(Today()-2);

SQL SELECT * FROM <Table>

[#9]

Thanks Satyadev,

I had tried that but still not working. Really appreciate your help here.

Best regards,

Andy

[jagan]

Hi,

What is the database? Is it Oracle/SQL Server/MySQL etc?

Try like this

TableName:

LOAD

    *

WHERE Year(DateFieldName)=> Year(Today());

SQL SELECT * FROM <TableName>;

OR (If you are using Oracle)

TableName:

SQL SELECT * FROM <TableName>

WHERE Extract(Year From DateFieldName);

In the above script replace TableName with your actual table name and replace DateFieldName with your actual date field name in table.

Regards,

jagan.