topic Re: using ValueLoop with date in QlikView

using ValueLoop with date

Fri, 10 Sep 2010 16:14:31 GMT

Hi all,

I need to generate a dinamic dimension with all date between an range. I try to use the function ValueLoop and this work fine but trasform my date in numeric format.

Example

MinDataRange = 19/07/2010

MaxDataRange= 22/07/2010

valueloop(MinDataRange, MaxDataRange) return 40378, 40379, 40380, 40381.

How to use the valueloop to have a date format output?

I try this command, but does not work fine: Date(ValueLoop(MinDataRange,MaxDataRange), 'DD/MM/YYYY')

Tks.

using ValueLoop with date

Fri, 10 Sep 2010 20:32:54 GMT

An alternative, try using a data island for the date. Populate a standalone table with a full calendar of dates. Then you could have a calculated dimension something like:

=if(Date>'15/01/2009' AND Date< '30/01/2009', date(Date))

Or of course use variables instead of hard coded range limits

=if(Date>startdate AND Date<enddate, date(Date))

using ValueLoop with date

Sat, 11 Sep 2010 07:45:05 GMT

Thanks Tom,

Your solution is ok for me.

Dp2000

Re: using ValueLoop with date

Anonymous — Thu, 14 Jan 2016 16:21:55 GMT

Hi Tom, sorry for waking up this post again. I have made almost exactly the same you mentioned above and chart takes too long to show the data. Have you got better method to improve performance?

Thanks