topic Re: How to get values through expression in QlikView

How to get values through expression

Tue, 04 Feb 2014 12:00:07 GMT

Hi,

I have one expression in staright table and the expression is

sum(if(DateUpdate<DueDate and not isnull(DateIssue),1,0))

Could anyone let me know how can I change above expression so that I need to get the values for MAX(DateUpdate)

Please help me.

Thanks.

nilesh_gangurde — Tue, 04 Feb 2014 12:04:47 GMT

At script level you cant take max date.

instead you can do at the Expression level in chart using set analysis.

put this in the script :

if(DateUpdate<DueDate and not isnull(DateIssue),1,0) as New_Field

and in chart expression

Sum( {<New_Field = {1},DateUpdate = {"$(=Max(DateUpdate))"}>} Field_Name )

-Nilesh

Tue, 04 Feb 2014 12:07:12 GMT

Thanks and I have DateUpdate and DateIsuue in separate tables. How can I enter in script? please help me.

Tue, 04 Feb 2014 12:18:46 GMT

and also what is Field_Name? please let me know

Tue, 04 Feb 2014 12:32:27 GMT

Please can anyone help me

nilesh_gangurde — Tue, 04 Feb 2014 13:13:27 GMT

First take the Dates which you required to build logic into single Temp Table and then do the above mentioned logic.

-Nilesh

MK_QSL — Tue, 04 Feb 2014 13:30:50 GMT

FIRSTSORTEDVALUE(sum(if(DateUpdate<DueDate and not isnull(DateIssue),1,0)),

-IF(DateUpdate<DueDate,DateUpdate))

FIRSTSORTEDVALUE(sum(if(DateUpdate<DueDate and not isnull(DateIssue),1,0)),

IF(DateUpdate<DueDate,DateUpdate))

Tue, 04 Feb 2014 13:39:00 GMT

Thanks and when I am passing this it is showing error in expression.