topic Re: Need idea for finding gaps in QlikView

Need idea for finding gaps

k_burata — Mon, 22 Oct 2018 07:50:20 GMT

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

Re: Need idea for finding gaps

Anil_Babu_Samineni — Mon, 22 Oct 2018 08:16:14 GMT

What you want to fill there?

Re: Need idea for finding gaps

k_burata — Mon, 22 Oct 2018 08:21:47 GMT

Just change the colour to red to identify the gaps

Here's my tables if it helps.

Re: Need idea for finding gaps

Anil_Babu_Samineni — Mon, 22 Oct 2018 08:34:03 GMT

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())

Re: Need idea for finding gaps

Anil_Babu_Samineni — Sat, 27 Oct 2018 03:35:27 GMT

Have you get a chance to look?