topic Re: Field in the ValueLoop() function in QlikView

Field in the ValueLoop() function

Mon, 04 Jan 2016 08:33:00 GMT

Hello all,

I would like to ask you if it possible for me to somehow have fields in ValueLoop function.

I want to create dimension that will be used as a date.

= ValueLoop(PlannedStart,PlannedEnd,1) something like this

And is it possible to format this as a date, because like this is not working: =Date(ValueLoop(42331,42341,1),'DD.MM.YYYY')

Thanks

tresB — Mon, 04 Jan 2016 08:51:29 GMT

= ValueLoop(PlannedStart,PlannedEnd,1) - is poosible provided your fields have only one value in the scope (or selected).
Date(ValueLoop(... - seems not working

HirisH_V7 — Mon, 04 Jan 2016 09:02:33 GMT

Hi,

Your Dimension is ok:

ValueLoop(PlannedStart,PlannedEnd,1)

Expression should be ,

=Pick( Match(ValueLoop(PlannedStart,PlannedEnd,1) ,Date(PlannedStart,'DD/MM/YYYY'),Date(PlannedEnd,'DD/MM/YYYY'))

HTH,

Hirish

marcus_sommer — Mon, 04 Jan 2016 09:07:12 GMT

- Marcus