Discussion Board for collaboration on QlikView Scripting.
Hi all members
i have one problem
i use like this exemple
i want to load the max date for any Task like
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
how can i do
i used like this script
(MakeDate(1900+left(DateTask,3))+mid(DateTask,4)-1) as DateTask ;
Tache as Task,
date as DateTask,
Task as Dimension
Does not work
Provide sample app
Create a Straight Table
Max(date) as DateTask,
FROM "database" Group By Tache;
In the Straight table take dimension as Task and expression as Aggr(Max(DateTask),Task)
Check my solution.
Look at this.
Seems to be working, what isn't working for you?