Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm New to Qlik,
I have small challenge like, I want to see first 7 days and 14, 21, 28 days of a month.
I'm Passing year and month values through filter pane
date format MM/DD/YYYY.
Your suggestions appreciated.
Thanks,
Naveen
Or..
When loading your date use something like
if(Day(DateField)<=7,1,0) as [7 Day Flag],
if(Day(DateField)<=14,1,0) as [14 Day Flag],
.....
You might cluster them with: ceil(day(DATE) / 7)
- Marcus
Or..
When loading your date use something like
if(Day(DateField)<=7,1,0) as [7 Day Flag],
if(Day(DateField)<=14,1,0) as [14 Day Flag],
.....
Thanks Dilip,
As a Variable that is working fine
Regards
Naveen