Conditional Formating in Qlikview

[#1]

Hi,

here find the attached excel of conditional formating in which i have Net of PE with the previous day.

formula is as:

If Net of PE of 1st jan would be greater than 31st dec so it would be green and if less than then it would be red.

How do i give same condition in Qlikview.

County	31st Dec			1st Jan			2nd Jan			3rd Jan			4th Jan
	Billing	PE	Net of PE	Billing	PE	Net of PE	Billing	PE	Net of PE	Billing	PE	Net of PE	Billing	PE	Net of PE
BHANDARA	255	15	240	263	23	240	263	23	240	263	23	240	263	22	241
CHANDA	255	19	236	263	27	236	263	27	236	263	27	236	263	22	241
GONDIA	250	20	230	258	28	230	258	28	230	258	28	230	258	22	236
GADCHIROLI	255	19	236	263	27	236	263	27	236	263	27	236	263	22	241
NAGPUR	260	13	247	268	21	247	268	21	247	268	21	247	268	8	260

[ArnadoSandoval]

Hi Trapti

You excel example does not contain a good sample to test your condition, I just modified it a bit, and re-attach the file to my reply. The condition you need to add to the 1st Jan Billing background function is:

if([1st Net of PE] > [31st Net of PE], rgb(0, 255, 0), if([1st Net of PE] < [31st Net of PE], rgb(255,0,0)))

I also attached a sample QVF with the solution.

Hope this helps

[#3]

Hi,

I am not able to open this qvf file.

Also pls paste the script on the mail bady so that i'll try to work from that

[ArnadoSandoval]

Hi Trapti,

Nothing is done in the script, applying background color to a table's column is done at the table's interface.

The background color expression is:

if([1st Net of PE] > [31st Net of PE], rgb(0, 255, 0), if([1st Net of PE] < [31st Net of PE], rgb(255,0,0)))

Hope this helps.

[ArnadoSandoval]

Forgot to attach this image

[#6]

Thanks.

But in Qlikview i have modified these fields with other name.

pls help me to apply it here.

i am attaching the qlikview

[#7]

I am trying to apply here

if(2 NOP) >(1 NOP), rgb(0, 255, 0), if([2 NOP] < [1 NOP], rgb(255,0,0)))

But it not working