topic Re: Week's Min & Max Date as Dimension? in QlikView

Week's Min & Max Date as Dimension?

Tue, 21 Jan 2014 17:42:54 GMT

I am trying to display the start and end dates of a week as a dimension in a line chart. I have a Date field and a Week field, but can't figure out how to put the two together so that one dimension would show a value for things completed between 10/20/2013 - 10/26/2013, for example. The attached image shows what I am trying to do. Any help would be appreciated.

Re: Week's Min & Max Date as Dimension?

Gysbert_Wassenaar — Tue, 21 Jan 2014 17:59:01 GMT

Use a calculated dimension: =weekstart(MyDate) & '-' & weekend(MyDate). Or create a field using that expression in the script and use the new field as dimension.

Re: Week's Min & Max Date as Dimension?

Nicole-Smith — Tue, 21 Jan 2014 18:01:36 GMT

Another option is to use the class function. See the attached for an example.

Re: Week's Min & Max Date as Dimension?

Tue, 21 Jan 2014 18:24:19 GMT

Gysbert Wassenaar, that's it! The only issue I have now is sorting, especially now in the new year since we have dates from early months this year and late months last year. I've tried using all of the Sort by defaults but they don't get it right, I'm guessing some type of expression will need to be used?

Re: Week's Min & Max Date as Dimension?

Tue, 21 Jan 2014 18:40:06 GMT

Class function is a possibility. Another is to order your "week strings" according to an expression, like:

=Avg(MyDate)

ascending. Should work here.

Re: Week's Min & Max Date as Dimension?

Clever_Anjos — Tue, 21 Jan 2014 18:43:12 GMT

To fix sorting use weekstart(MyDate) as Sorting Expression