Date to Week

[shree909]

Hi i have a week dimension , date dimenion

i have a bar chart with date dimeniosn and one expression

the bar chart shows all the dates for that expression

but the issue is i want to show only the latest week date by default..

so what would be the expression

my expression is sum(sales)

[montero91]

hi Shree909

if i understand, you will need is create a dimension with

WeekEnd(Date) as WeekEnd

and used for the group by week but with the label of the weekend

[#3]

Try SUM({<Week={$(=Max(Week)}>} Sales) Where Week is your week dimension.

[shree909]

thanks for the quick reply

i want to use that as a dimesion

in the dimenion i have takedn date field but that date filed has to show only the latest week dates dimesion...

[#5]

If you use the expression it will only show the results for the dates of that week so also only the dates for that week.

Try it, otherwise attach a sample qvw file where I can check your chart.

Greetings,

Marc