Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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

Labels (1)
4 Replies
Anil_Babu_Samineni
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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