Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Highlight misorder in Date

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.

Labels (1)
18 Replies
Highlighted
Partner
Partner

I've edited your sample.xlsx (see attachment) and it still works even with deleting rows and null values.

Jordy

Climber

Work smarter, not harder
Highlighted
Creator II
Creator II

Please find attached screenshot, I getting mismatch while trying for the same model in my qvf

Highlighted
Partner
Partner

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

Work smarter, not harder
Highlighted
Creator II
Creator II

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?

Highlighted
Partner
Partner

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

Work smarter, not harder
Highlighted
Creator II
Creator II

Working except for the first row of every project. 

Highlighted
Partner
Partner

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

Work smarter, not harder

View solution in original post

Highlighted
Creator II
Creator II

It works!!!. Thank you so much
Highlighted
Partner
Partner

Good to hear, success!

Jordy

Climber

Work smarter, not harder