Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field in the ValueLoop() function

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

3 Replies
tresesco
MVP
MVP

  • = 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
Master
Master

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


HirisH
“Aspire to Inspire before we Expire!”
marcus_sommer
MVP & Luminary
MVP & Luminary

Here is a workaround: using ValueLoop with date

- Marcus