Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bouderbc
Creator
Creator

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

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 dateext.PNG

//Filter where date_Extract>Date creation

FROM

C:\Users\Desktop\Tablemodele.xlsx

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

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;

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

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

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];