Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
But I dont know where to put it
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.
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