topic Re: the max method in set analysis in QlikView

the max method in set analysis

Mon, 18 Jan 2016 07:29:56 GMT

Hi all members

i have one problem

i use like this exemple

Task	DateTask
T1	13/12/2015
T1	01/12/2015
T1	03/10/2014
T2	01/01/2016
T2	03/01/2016
T3	06/01/2016

i want to load the max date for any Task like

Task	DateTask
T1	13/12/2015
T2	03/01/2016
T3	06/01/2016

i used a variable vMaxDate=date(max(DateTask)) ( i wrote = )

but the result is not OK, when i select one row in chart table i get the good value ,but in the first display for all values it desplay one values of all rows

Tache	Date
T1	13/01/2016
T2	13/01/2016
T3	13/01/2016

how can i do

thanks all

Re: the max method in set analysis

Mon, 18 Jan 2016 07:43:08 GMT

i used like this script

load

Distinct Task,

(MakeDate(1900+left(DateTask,3))+mid(DateTask,4)-1) as DateTask ;

SQL SELECT

Tache as Task,

date as DateTask,

FROM "database".

Re: the max method in set analysis

MK_QSL — Mon, 18 Jan 2016 07:49:08 GMT

Try

Task as Dimension

Expression

FirstSortedValue(DateTask, -Aggr(Max(DateTask),Task))

Re: the max method in set analysis

Mon, 18 Jan 2016 08:01:19 GMT

Does not work

Re: the max method in set analysis

MK_QSL — Mon, 18 Jan 2016 08:21:11 GMT

Provide sample app

Re: the max method in set analysis

MK_QSL — Mon, 18 Jan 2016 09:12:15 GMT

Create a Straight Table

Dimension

Task

Expression

Date(Max(DateTask))

Re: the max method in set analysis

nilesh_gangurde — Mon, 18 Jan 2016 09:15:11 GMT

Use this

load

Distinct Task,

(MakeDate(1900+left(DateTask,3))+mid(DateTask,4)-1) as DateTask ;

SQL SELECT

Tache as Task,

Max(date) as DateTask,

FROM "database" Group By Tache;

In the Straight table take dimension as Task and expression as Aggr(Max(DateTask),Task)

Regards,

Nilesh

Re: the max method in set analysis

miguelbraga — Mon, 18 Jan 2016 09:33:21 GMT

Hi there,

Check my solution.

Regards,

Re: the max method in set analysis

senpradip007 — Mon, 18 Jan 2016 10:10:28 GMT

Look at this.

Re: the max method in set analysis

sunny_talwar — Mon, 18 Jan 2016 10:14:40 GMT

Seems to be working, what isn't working for you?

Re: the max method in set analysis

Wed, 20 Jan 2016 08:44:31 GMT

Hi all member and thanks for your answer

it doesn't work with my script i Used a pivot Table in expression not dimenssion

this Tache is a concatination between other field, and join it with other table :

for the first table:

load

Distinct NameTache&'-'typeTask as Tache,

(MakeDate(1900+left(DateTask,3))+mid(DateTask,4)-1) as DateTask ;

SQL SELECT

NameTache,

typeTask,

DateTask // the max methode doesn't work here max(DateTask) as dateMax an error message apear that we cann't put the max methode

FROM "database" ;

-------------------------------------------------------------------

for the second table:

load

Distinct NameTacheee&'-'typeTaskeee as Tache,

SQL SELECT

NameTache,

typeTask,

FROM "database" ;