Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
k_burata
Creator
Creator

Need idea for finding gaps

I have this Pivot Table in QV. I need to change the background colour whenever there is a gap per position.

Like in the one below for POS1 there is a gap on the 15/11.

Can this be done in Set Analysis or do I do it on the Load Script?

Capture.PNG

Thanks

4 Replies
Anil_Babu_Samineni

What you want to fill there?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
k_burata
Creator
Creator
Author

Just change the colour to red to identify the gaps

Here's my tables if it helps.

Capture.PNG

Anil_Babu_Samineni

We really, can't Color in script. So, We can think in design now? Instead What is the Measure and Label Name, You've applied? If Label Name is Expression then, You can identify like.


If(IsNull(Expression), Red())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anil_Babu_Samineni

Have you get a chance to look?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful