Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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" ;