First Seven Days of a month?

[naveen409]

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

[marcus_sommer]

You might cluster them with: ceil(day(DATE) / 7)

- Marcus

[dplr-rn · Accepted solution]

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],
.....

[naveen409]

Thanks Dilip,

As a Variable that is working fine

Regards 

Naveen