Date related filtering issue with chart expressions

[trishita]

I need to pick up records or data only for sounding start date only which is after the survey start  date and in the range 7 days after the survey startsdate..I dont know where and how to put the expression in the chart

If([SOUNDING_START_DATE] >= [SURVEY_START_DATE] and [SOUNDING_START_DATE] < [SURVEY_START_DATE] + 7, 1, 0)

[MK9885]

The expression seem to be correct...

maybe

If([SOUNDING_START_DATE] >= [SURVEY_START_DATE] and [SOUNDING_START_DATE] < date(max([SURVEY_START_DATE] ))+ 7, SURVEY_ID, 0)

[trishita]

But I dont know where to put it

[MK9885]

Use this expression for your SURVEY_ID field instead.

I guess Calculated Dimension...

Or if you want I can do it but I'd need Sample data in XL.

Do not attach QVW file, I cannot open qvw's. I do not have full version of qlik.

Thanks.

[neelamsaroha157]

You can use this expression in your script as well to create a Flag and then use that flag in your expressions to limit data only for these records. Something like -

If([SOUNDING_START_DATE] >= [SURVEY_START_DATE] and [SOUNDING_START_DATE] < [SURVEY_START_DATE] + 7, 1, 0) as Flag  --use this in script

and then in front end  -

Count({<Flag = {'1'}>}Survey_ID) OR in your calculation of ROB