Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.