Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Cant get min expression to work properly!

 

Hello I have some data, a set of dates, the number of dates can vary, for example.

25.04.2005

26.08.2009

01.04.2012

I am trying to load where the 1st date is greater than 01.04.2012 and am using the following expression that is not working!

  

if(min(Date_Time_Slice_From>'01.04.2012'),Date_Time_Slice_From)

Any idea on how to get thisworking would be great,

Paul.

16 Replies

Re: Cant get min expression to work properly!

HI

Try like this

if(Date_Time_Slice_From>'01.04.2012',Date_Time_Slice_From)

Not applicable

Re: Cant get min expression to work properly!

No that didnt work at all! Ive still got data pre 01.04.2012!!!

Not applicable

Re: Cant get min expression to work properly!

In ur expression

create one variable for

min(Date_Time_Slice_From)

then use this variable in the expression

it useful

Not applicable

Re: Cant get min expression to work properly!

How? i've been unsuccessful in using MIn in script

Re: Cant get min expression to work properly!

Hi,

Are you using this in script whioch means you can limit this with Where clause

Load *

From Source

Where Date_Time_Slice_From>'01.04.2012';

If 01.04.2012 is not a default date format then you have to format using Date#(Date string, Format) function.

Hope this helps

Re: Cant get min expression to work properly!

HI

PFA

Regards,

R.MayilVahanan

Not applicable

Re: Cant get min expression to work properly!

no no no. Look at the original example I quoted, I want it where the earliest value is >01.04.2012

your example will load all data pre 2012.

Not applicable

Re: Cant get min expression to work properly!

I am only interested if the minimum value is 01.04.2012, I dont want to load any records where the earliest value is pre 2012.

Not applicable

Re: Cant get min expression to work properly!

im using this in table expression

create one variable for

min(Date_Time_Slice_From)

use this variable in expression like

if(date(1/1/2012)<=$(minvar),sum(price))

it work for me i check this

Community Browser