Discussion Board for collaboration on QlikView Scripting.
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')
Your Dimension is ok:
Expression should be ,
=Pick( Match(ValueLoop(PlannedStart,PlannedEnd,1) ,Date(PlannedStart,'DD/MM/YYYY'),Date(PlannedEnd,'DD/MM/YYYY'))
Here is a workaround: using ValueLoop with date