Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Godtooro
New Contributor

Load data from a specific date

Dear all,

 

First of all thank you for your support.

I´m trying to load data from a specific date onwards but I´m not able to do it,  taking as example this script:

LOAD
Ref.,
Artículo,

Posting Date (How can I do it here to set a start date higher than for example 01.01.2017?)
"Unidades Ventas",
"Importe Ventas Bruto",
"Importe Dtos.",
"Importe Ventas Netas",
"Coste Ventas Mov. Valor",
"% Dtos.",

 

All the best.

Labels (1)
2 Replies
alexpanjhc
Valued Contributor

Re: Load data from a specific date

LOAD
Ref.,
Artículo,

Posting Date ,//(How can I do it here to set a start date higher than for example 01.01.2017?)
"Unidades Ventas",
"Importe Ventas Bruto",
"Importe Dtos.",
"Importe Ventas Netas",
"Coste Ventas Mov. Valor",
"% Dtos."

where date(Posting Date,'MM/DD/YYYY') >='01/01/2017'

resident <yourfile/table>;

Partner
Partner

Re: Load data from a specific date


@Godtooro wrote:

[...]LOAD
Ref.,
Artículo,

Posting Date (How can I do it here to set a start date higher than for example 01.01.2017?)
"Unidades Ventas",
"Importe Ventas Bruto",
"Importe Dtos.",
"Importe Ventas Netas",
"Coste Ventas Mov. Valor",
"% Dtos.",

Where lies your trouble? Is it in the consept or  in the details? I believe that @Godtooro is pointing us in the right direction. By examening the details I notice two possible troubles, the field name does not have a quotation marks arount like this "Posting Date" and dateformats can be trouble. I'll try to write an answer similar to the previous answer, but where I try to rule out the two issues.

 

LOAD 
  Ref.,
  Artículo,
  [Posting Date] ,// Is it on the format MM.DD.YYYY or DD.MM.YYYY or other? Adjust the WHERE clause accordingly
  "Unidades Ventas",
  "Importe Ventas Bruto",
  "Importe Dtos.",
  "Importe Ventas Netas",
  "Coste Ventas Mov. Valor",
  "% Dtos."
WHERE 
   date#([Posting Date],'DD.MM.YYYY') >= date#('2017-01-01', 'YYYY-MM-DD')
FROM
   [Your source]
; 
#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.