Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone tell me what is wrong with my syntax here?
Only({$<Sounding Date -= {'N'}>} If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0))
I have also added my qvw with this reference
Couple of issues:
But I created an expression called Sounding Date:
Sounding date :
If(Flag1=1,Date(SOUNDING_START_DATE,'YYYY-MM-DD'), 'N')
So cant I use expressions in set analyisi
No. That is what precisely I wrote in first point above. You have to use field instead in set analysis.
I gave a flag called Flag1:
If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0)
Then I created an expression:
Sounding date :
If(Flag1=1,Date(SOUNDING_START_DATE,'YYYY-MM-DD'), 'N')
Lastly I want to show the data for Sounding Date {$<Sounding Date -= {'N'}>}
which means I want to exclude out all date with value N and only display the values for Flag1=1
I dont know whats wrong with my method:
So what could be a possible solution to only pick those data with flag1=1?
Do you wish to suppress all the other rows from the chart ?
yes i just want to show the data which has the value of flag 1.Something like this
PFA
I also tried to use a calculated dimension using If([SOUNDING_START_DATE] >= [SURVEY_DATE] and [SOUNDING_START_DATE] < [SURVEY_DATE] + 7, 1, 0) and then tried to supress null value from it..Still its not working