topic Re: Expression in syntax in QlikView

Expression in syntax

Fri, 09 May 2014 09:42:55 GMT

Hello,

I am using this expression Date={"=Max(LoginDate)"} and its not working...

Can anybody help to make it correct??

Re: Expression in syntax

its_anandrjs — Fri, 09 May 2014 09:46:59 GMT

Try to use like

Date ={'$(=Max(LoginDate))'}

Date ={"$(=Max(LoginDate))"}

Eg:-

Sum({<Date ={'$(=Max(LoginDate))'}>} ConstrumValue)

Re: Expression in syntax

CELAMBARASAN — Fri, 09 May 2014 09:54:36 GMT

Try this

Date={'$(=Date(Max(LoginDate)))'}

Your expression will be kind of below

Sum({<Date={'$(=Date(Max(LoginDate)))'}>} Sales)

Re: Expression in syntax

Fri, 09 May 2014 09:56:37 GMT

Anand,

not working....

Re: Expression in syntax

Fri, 09 May 2014 10:03:10 GMT

not working adhimulam

Re: Expression in syntax

Fri, 09 May 2014 10:11:46 GMT

hey navneet this expression wont work as u r comparing date with max of date and in the seletction you will have year and month

so rather you should write expression as following

Sum({<Year={"$(=max(Date_Year))"},Month={"$(=max(Date_Month))"}>}sales)

try like this

Re: Expression in syntax

anbu1984 — Fri, 09 May 2014 10:17:01 GMT

can you show your app?

Re: Expression in syntax

CELAMBARASAN — Fri, 09 May 2014 10:17:11 GMT

Is your Date field has the same format which is specified in DateFormat variable?

Re: Expression in syntax

its_anandrjs — Fri, 09 May 2014 10:18:25 GMT

Check the date format for fields Date and LoginDate that should be same in format.

Re: Expression in syntax

its_anandrjs — Fri, 09 May 2014 10:25:37 GMT

See the below example for the same problem

LOAD Date(TranDate,'MM/DD/YYYY') AS TranDate,Sales;

LOAD * Inline

[

TranDate,Sales

1/1/2014,3343

1/2/2014,454

1/3/2014,65

1/4/2014,64767

1/5/2014,7676

1/6/2014,7767

1/7/2014,7676

1/8/2014,7676

1/9/2014,767434

1/10/2014,767

];

Dimension:- TranDate

Expression:- Sum({<TranDate ={'$(=Max(TranDate))'}>} Sales)

The result will be 767 for max date 1/10/2014

Re: Expression in syntax

Fri, 09 May 2014 10:27:22 GMT

so there is no separate calendar with which you will compare this TranDate ???

Re: Expression in syntax

its_anandrjs — Fri, 09 May 2014 10:51:07 GMT

Hi Navneet,

By storing the max value in the variable you can also sum the

Source:

LOAD Date(Date,'M/D/YYYY') AS Date, Date(LoginDate,'M/D/YYYY') AS LoginDate,Sales;

LOAD * INLINE [

Date, Sales, LoginDate

1/1/2014, 3343, 1/1/2014

1/2/2014, 454, 1/1/2014

1/3/2014, 65, 1/2/2011

1/4/2014, 64767, 1/3/2014

1/5/2014, 7676, 2/1/2012

1/6/2014, 7767, 1/10/2014

1/7/2014, 7676, 1/1/2012

1/8/2014, 7676, 1/10/2014

1/9/2014, 767, 1/1/2014

1/10/2014, 767, 1/1/2014];

MaxTable:

LOAD

Date(Max(LoginDate))as MaxDate

Resident Source;

LET vMax = Peek('MaxDate',0,'MaxTable');

And in front end

Dimension:- Date

Expression:- Sum({<Date ={'$(=vMax)'}>} Sales)

But check the date formats of the fields but i suggest use variables for finding the max dates by storing the max date in the variable and then use it on the expression.