topic Re: Conditional formating colour in QlikView

Conditional formating colour

Thu, 14 May 2015 15:28:55 GMT

Hi,

I have a really strange problem.

I have text boxes with formulas in showing numbers and a variance box to show the difference between the two. I have used a formula to show when one is greater than the other show green otherwise red. It works but then as you start filtering for specialities etc it doesnt work, and its showing red when it should show green etc - but the formula appears correct and it sometimes works!!

Is there something i am missing?

Re: Conditional formating colour

Anonymous — Thu, 14 May 2015 15:30:24 GMT

Can you please share your document to take a look?

Re: Conditional formating colour

Clever_Anjos — Thu, 14 May 2015 15:32:54 GMT

Please attach a sample of your app to look it

Re: Conditional formating colour

Thu, 14 May 2015 15:58:44 GMT

Sorry i dont know how to attach a document from our server. I have taken some screen shots though to show you ...? For example look at the inpatient waiting list variance - works in the first one. then i filter for ENT and its still green yet there were more in's than outs...?

Re: Conditional formating colour

Anonymous — Thu, 14 May 2015 16:23:20 GMT

When you are answering, there's an "Use advanced editor" link on the right top corner of the gray edit section, once you click there, on the right bottom corner there's the "attach" option.