Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
victor_greffet
Partner - Contributor III
Partner - 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

0 Replies