Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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