Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-04-13 10:16 AM

Where clause in LOAD

IS it possible(I cant make it work) to put in a WHERE clause in the load sequence - somthing like this:

LOAD
left([sales],4) as lastyear
WHERE [sales] = 2008.

the sales list is a column with dates in this format dd-mm-yyyy

7,289 Views
0 Likes
10 Replies
Not applicable
‎2010-04-14 09:27 AM
Author

In response to Miguel_Angel_Baeyens

Hi Miguel

It wont load properly.
What I´m trying to do is(I have made another post about it but I dont get enything I can use) is to show an increase in sold items in year 2008 and 2009.

I got one list with all the sales dates representing 1 sold item per date.
Showing the frequency in my list give me the total of dates in 2008 and 2009.

2008, 1000 dates and 2009 2000 dates so its an increase of dates of 1000 or 100% increase, but how do I make the script
do thsi for me?

171 Views
0 Likes