Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjoir,
HELP! Je voudrais selectionner les enregistrements du dernier jour de chaque MoisAnnée dans le script load.
Exemple:
text3
le resultat doit etre :
Merci d'avance
Harshita Gaur
thank you
but is not working !
vous faite la formule de calcule dans la table.
moi je veux avoir une resultat finale au restitution , donc je voulais faire manupilation au moment de chargement des données
did you see the latest qvw, attached by me?
Hello again,
i tried that:
load
MakeDate(Year(Date),Month(Date),Max(day(Date))) as MAxDayPerMonth,
Enregistrement
resident Table1;
but Error in " Max(day(date))"
my file is:
date enregistrement
01/08/2012 1
02/08/2012 2
10/08/2012 3
09/09/2012 4
i need to get the table:
Date enregistrement
10/08/2012 1
Thanks for your help
Oui, mais vous faite l'expression
(F1=max(aggr(nodistinct max( F1),month_date)),F3,0)
i need a formule for
Load ....... resident......
not in the graphique !
I need data for every month but JUST the last day for each month !
@andu cheliyan
thanks but i tried , it s not working !
You can try the QVW, this time its in script.Sorry for the confusion.
hope it helps this time
It worked for me
What was the problem?
10/08/2012 1 ????? shoudl this be 3
Yes 3
sorry
i want to get all the date with the data just the exception is:
if i have ONE data per Month -----> ok no change
If i have MORE THAN 1 data per month -------> get the last data for this month
