topic displaying current weeks data in QlikView

displaying current weeks data

Wed, 06 Aug 2014 04:09:35 GMT

i am trying to display a set of data according to the days of the weak.. as shown in the image...

the issue i have is how can i extract the data only for the current week ?? (i need to display the data only of the present week. at the moment it combines all days of the month and display )

would appriciate if some one could help me with this issue

thank you in advance

Re: displaying current weeks data

ecolomer — Wed, 06 Aug 2014 04:22:47 GMT

Yu can use the week function for have the number of week in the year and select the actual week

Week(Now()) = 32

If you need more explain, tell me

Saludos,

Enrique Colomer

Example for Calendar:

LET vMin=num(Peek('FechaMin',0,'FEC_LIM'));

LET vMax=num(Peek('FechaMax',0,'FEC_LIM'));

CAL:

LOAD

Date(IterNo()+$(vMin)-1) as CFecha,

Year(Date(IterNo()+$(vMin)-1)) as CAño,

Month(Date(IterNo()+$(vMin)-1)) as CMes,

Week(Date(IterNo()+$(vMin)-1)) as CSemana,

WeekStart(Date(IterNo()+$(vMin)-1)) as CSemIni,

WeekEnd(Date(IterNo()+$(vMin)-1)) as CSemFin

AutoGenerate 1 While IterNo()+$(vMin)-1<=$(vMax);

Re: displaying current weeks data

sujeetsingh — Wed, 06 Aug 2014 04:24:29 GMT

Just use a variable which takes the current selected week if selection made else it will take the max week of the calender .