Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a projects with 6 sub projects say for eg. Project1 has subprojects1, subprojects2, subprojects3, subprojects4, subprojects5, subprojects6, subproject7, subprojects8 and subprojects9
Every sub projects should have to be completed after the previous subproject.
Project,SP,FinishDate(MM/DD/YYYY)
P1,SP1, 02/02/2019
P1,SP2, 02/04/2019
P1,SP3, 02/06/2019
P1,SP4, 02/12/2019
P1,SP5, 02/14/2019
P1,SP6, 02/13/2019
P1,SP7, 02/16/2019
P1,SP8, 02/20/2019
P1,SP9, 02/22/2019
Here SP6 finished before the SP5 finish date by 1 day. So I want to highlight the subproject SP6 and Project P1.
I've edited your sample.xlsx (see attachment) and it still works even with deleting rows and null values.
Jordy
Climber
Please find attached screenshot, I getting mismatch while trying for the same model in my qvf
Do you have selected all the dimensions like you have them in your data model? Otherwise it won't work correctly. Can you share that QVF that you use?
Jordy
Climber
No. I selected for a particular dimensions. Also, I am working in hub. I tried with sample data, it's working fine, but not with real data. Is there any other way?
You can try to include the sub project in the IF statement with the Above() function. It doesn't work with real data because you select your own variables.
Jordy
Climber
Working except for the first row of every project.
Good, that means we're almost there. You should create another IF with:
IF(Above(Project) <> Project, Black(), IF(.... [next one]
Because every first one should be black of course.
Jordy
Climber
Good to hear, success!
Jordy
Climber