Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarajan_iyer
Contributor II
Contributor II

Creating a loop

I am looking to create a look for dates. I have a date column with random dates knows as Rcd_Dt and i want to create a new column as Ctr_dt with a group of dates from the Rcd_dt

e.g. 14th Jan 18 to 13th Feb 18 in Rcd_dt as Month 1 in Ctr_dt

14th Feb to 13th March 18 in Rcd_dt as Month 2 

so i basically want to create a loop instead of using an If condition and keep adding multiple conditions. 

Thanks a lot for the help in advance.

3 Replies
marksouzacosta
Partner - Creator II
Partner - Creator II

Hi,

I think you'll have to use IntervalMatch to solve this problem:
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

 

Regards,

Mark Costa

Get hooked on Qlik at qlikbait.net
YoussefBelloum
Champion
Champion

Hi,

do you need every month (from 14 to 13) on a new column ?

Would you be able to share sample data ?
nagarajan_iyer
Contributor II
Contributor II
Author

Unfortunately i woudnt be able to. But what i need is be able to classify

14 to 13 into as month 1 in the new column so that i could use the new column to filter while creating the app.

so instead of filtering from 14th to 13th in the app ill use the new column to filter and say Month 1 directly.