topic Need help on conditional formatting in QlikView

Need help on conditional formatting

Mon, 20 Feb 2012 14:08:50 GMT

The report has one dimension brand and one expression Sum(Sales). Average of total sales should be displayed on the reprot as Total. And the background color of sales should be based on the following conditions.

If(Sum(Sales)>=19000,RGB(0,127,0),If(Sum(Sales)<=4500,RGB(255,0,0),white()))

These conditions have been specified in the expression background as below. The background colors for brands are according to the given conditions but not the Total row as below.

The background colors for brands are according to the given conditions but not the Total row as below.

Please help me on this so that Total background color should be according to the given conditions.

Please find attached for the sample application.

Thank you.

Regards,

kmiryalapl.

Need help on conditional formatting

CELAMBARASAN — Mon, 20 Feb 2012 14:17:39 GMT

Hi,

Check by Increasing the column space.i mean widening the width of the column which shows total in ##### format.

Celambarasan

Re: Need help on conditional formatting

jagan — Mon, 20 Feb 2012 14:50:25 GMT

Hi,

Please find the sample attached. Use the Visual Clues section to give styles.

Regards,

Jagan.

Need help on conditional formatting

Mon, 20 Feb 2012 15:04:52 GMT

Thanks Jagan for your reply.

Actually, for my requirement I have three set of conditions, which I feel cannot be placed in visual cues. Below are the conditions.

if(variance>90 or variance<-90,rgb(255,34,34),

if(variance>45 and variance<=90 or variance<-45 and variance>=-90,RGB(255,128,0),

if(variance<=45 or variance>=-45,Green())))

Is there a way to put these conditions in visual cues? If yes, please let me know that, if not please let me know for any work around.

Thank you.

Regards,

kmiryalapl.

Re: Need help on conditional formatting

jagan — Mon, 20 Feb 2012 15:16:00 GMT

Hi,

I think there is no option for 3 conditions in Visual clues. You can give only two conditions <= and >= and default.

Instead you can by adding another chart below for displaying total. Check the attachment.

Regards,

Jagan.

Need help on conditional formatting

Mon, 20 Feb 2012 15:51:03 GMT

Users should be able to export the report to excel. If we use two reports, they cannot export both the reports at once. And we should not use any macro.

Thank you.

Regards,

kmiryalapl

Need help on conditional formatting

Tue, 21 Feb 2012 14:32:13 GMT

Anyone, please help.........

Need help on conditional formatting

rajeshvaswani77 — Tue, 21 Feb 2012 14:42:50 GMT

Go to expressions click on the plus sign and then Background expressions. Thats how we did on one of our project. The Visual Cues also puts the expression embedded there, use multiple if statements qith RGB to set the appropriate color.

thanks,

Rajesh Vaswani