Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

victor_greffet
New Contributor III

Loop for testing different columns

Hi community !

I need your help,

In my script, i'd like to create a test on different type of date, and put a warning when the date is on Christmas or on the first of the year

I have five differents type of dates :

DATA :

ID

Step0Step1Step2Step5Step9

1

12/12/201710/12/201710/12/201718/12/201718/12/2017
201/01/201710/12/201713/12/201718/12/201718/12/2017
312/12/201710/12/201710/12/201725/12/201725/12/2017
410/12/201710/12/201718/12/201718/12/201718/12/2017
........
n12/12/201710/12/201710/11/201718/12/201718/12/2017

What I want :

DATA :

IDStep0Step1Step2Step5Step9Test

1

12/12/201710/12/201710/12/201718/12/201718/12/2017ok
201/01/201710/12/201713/12/201718/12/201718/12/2017Warning Step0 it's 01/01
312/12/201710/12/201710/12/201725/12/201725/12/2017
Warning Step5 it's 25/12 , Warning Step9 it's 01/01
410/12/201710/12/201718/12/201718/12/201718/12/2017ok
........
n12/12/201710/12/201710/11/201718/12/201718/12/2017

ok

Do you  have an idea ?

Thank you !

Victor

Community Browser