Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
We have around 7 years of data in our database and tring to reload it all causes Qlikview to slow up and crash. Currently Im using the option of "Always one selected value". But this isn't ideal as the other tabs require multiple dates, and the date sets are from a different field so it conflicts.
Here is a sample of the code that I have in the script for the receipt dates.
//BatchesLOAD Date(syscreated,'DD/MM/YYYY') as ReceiptDate,
Date(MonthStart(syscreated),'MMM-YY') as MonthReceipted,
text(Date(MonthStart(syscreated),'MMM')) as MthReceipted,
Date(YearStart(syscreated),'YYYY') as YearReceipted,
ItemCode as ReceiptCode,
Number as Batch,
syscreated as Receipted;
SQL SELECT
ItemCode,
Number,
syscreated
FROM "009".dbo.ItemNumbers;
What could I add into the code so that it will only ever retrieve data from 2011 onwards?
Thank you.
This depends a bit on your data format but you could try to add
Where Year(syscreated) > '2010' ;
So:
//BatchesLOAD Date(syscreated,'DD/MM/YYYY') as ReceiptDate,
Date(MonthStart(syscreated),'MMM-YY') as MonthReceipted,
text(Date(MonthStart(syscreated),'MMM')) as MthReceipted,
Date(YearStart(syscreated),'YYYY') as YearReceipted,
ItemCode as ReceiptCode,
Number as Batch,
syscreated as Receipted;
SQL SELECT
ItemCode,
Number,
syscreated
FROM "009".dbo.ItemNumbers
Where Year(syscreated) > '2010';
Let me know if this works for you.
Good Luck,
Dennis.
This depends a bit on your data format but you could try to add
Where Year(syscreated) > '2010' ;
So:
//BatchesLOAD Date(syscreated,'DD/MM/YYYY') as ReceiptDate,
Date(MonthStart(syscreated),'MMM-YY') as MonthReceipted,
text(Date(MonthStart(syscreated),'MMM')) as MthReceipted,
Date(YearStart(syscreated),'YYYY') as YearReceipted,
ItemCode as ReceiptCode,
Number as Batch,
syscreated as Receipted;
SQL SELECT
ItemCode,
Number,
syscreated
FROM "009".dbo.ItemNumbers
Where Year(syscreated) > '2010';
Let me know if this works for you.
Good Luck,
Dennis.
Thank you. This appears to have worked perfectly.