topic Re: How to make Filters on dates with conditions ? (conditional load) in QlikView

How to make Filters on dates with conditions ? (conditional load)

bouderbc — Thu, 28 Sep 2017 21:10:14 GMT

Hi experts ,

How to make Filters on dates with conditions ? (conditional load)Please see The attached sample ?

Request: i want to make a filter and load data with [Date Extract] -30 days and where Date Extract> Date creation

Table:

LOAD [Date Extract],

[Date creation],

[Champ Num],

[Champ Text],

[Date Extract]-30 as date_Extract

//Date extract //Minus 30 Days

//Filter where date_Extract>Date creation

FROM

C:\Users\Desktop\Tablemodele.xlsx

vishsaggi — Thu, 28 Sep 2017 23:12:12 GMT

Try like this?

LOAD *

WHERE date_Extract > [Date creation];

LOAD [Date Extract],

[Date creation],

[Champ Num],

[Champ Text],

[Date Extract]-30 as date_Extract

FROM

C:\Users\Desktop\Tablemodele.xlsx;

its_anandrjs — Fri, 29 Sep 2017 03:26:02 GMT

Try to load by this way and crate a field for Date Extract - 30 as Date-Extract

Data:

LOAD [Date Extract],

[Date creation],

[Champ Num],

[Champ Text],

if([Date Extract] > [Date creation],1,0) as Flag,

Date([Date Extract]-30) as date_Extract

FROM

Tablemodele.xlsx

(ooxml, embedded labels, table is [Table modele])

Where [Date Extract] > [Date creation];