Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks
What you want to fill there?
Just change the colour to red to identify the gaps
Here's my tables if it helps.
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())
Have you get a chance to look?