topic Re: Date to Week in QlikView

Date to Week

shree909 — Mon, 25 Feb 2013 19:54:35 GMT

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 — Mon, 25 Feb 2013 20:08:39 GMT

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

Mon, 25 Feb 2013 20:09:11 GMT

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

shree909 — Mon, 25 Feb 2013 20:34:23 GMT

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...

Mon, 25 Feb 2013 20:43:05 GMT

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