topic DISPLAY DAYS OF THE WEEK in QlikView

DISPLAY DAYS OF THE WEEK

Fri, 11 Jul 2014 14:17:57 GMT

I have a Bar CHart with Completion Week as Dimension and have following fields available

Completion Date

Completion Day

Completion Week

Count({<[Completion Year] = {'2014'}, [Module Status] = {'Completed'}>} [Module Status])

Now I wanna display the Count for each Week in a Bar Chart, I am getting the right result, but in the display I wanna display the week Dasy instead of the Week NO

For example Week 28 I wanna Display (07/01/2014-07/06/2014)

Any Help is appreciated

Re: DISPLAY DAYS OF THE WEEK

MK_QSL — Fri, 11 Jul 2014 14:32:08 GMT

You can use....

Below aggregated dimension

WeekStart([Completion Date]) & ' - ' & WeekEnd([Completion Date])

instead of [Completion Week]

Re: DISPLAY DAYS OF THE WEEK

rustyfishbones — Fri, 11 Jul 2014 14:34:29 GMT

Try adding the following as Your Dimension

=WEEKSTART(Date) & ' - ' & WEEKEND(Date) & ' (' & Week & ')'