topic Re: Text Color Expression not working in totals of Straight Table in QlikView

Text Color Expression not working in totals of Straight Table

christianjmz — Thu, 01 Sep 2016 18:56:05 GMT

Hi everyone,

my first post/question here...

I have an issue with totals in a straight table. In the text color expression within my 'YoY' expression, I have calculated colors based on threshold values (positive = green, 0 = black, negative = red) , expression here:

=If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) <0.005 and

($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) > -0.005, Black(),

If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) >0.005, Green(), LightRed()))

Until here, everything works fine, but the totals. They are not following the text color expression and text color of total is always red, no matter if it's a positive or zero number. I have "average" in Total Mode, because with Expression Total it just doesn't show any totals.

Any suggestion here?

Thanks

Re: Text Color Expression not working in totals of Straight Table

hirenjadiya — Thu, 01 Sep 2016 19:30:36 GMT

Hi,

Try using Visual Cues Tab in Straight Table (ref. image attach)

Custom Format Cell (ref. image attach)

Re: Text Color Expression not working in totals of Straight Table

sinanozdemir — Thu, 01 Sep 2016 19:36:15 GMT

Hi,

If you want your totals to change, then you need to use Dimensionality() function. Where the Dimensionality() = 0 is the totals row.

Hope this helps.

Re: Text Color Expression not working in totals of Straight Table

rupamjyotidas — Thu, 01 Sep 2016 20:05:20 GMT

I would follow what Sinan has recommended, you need to use Dimensionality() function to get the color right for Total

Re: Text Color Expression not working in totals of Straight Table

christianjmz — Thu, 01 Sep 2016 20:39:12 GMT

Hi @Sinan, thanks for the advice,

I'm not sure about how to use Dimensionality(), I've tried this but it's doing the same...

=If(Dimensionality()<>0,If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) <0.005 and

($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) > -0.005, Black(),

If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) >0.005, Green(), LightRed())),

If(Dimensionality()=0,If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) <0.005 and

($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) > -0.005, Black(),

If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) >0.005, Green(), LightRed()))))

Please, correct me if I'm wrong, thanks.

Re: Text Color Expression not working in totals of Straight Table

sinanozdemir — Thu, 01 Sep 2016 20:52:17 GMT

Try the below:

=If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) <0.005 and

($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) > -0.005, Black(),

If(($(vCSATAMS) - $(vDSATAMS))-($(vCSATL1AMS) - $(vDSATL1AMS)) >0.005 And Dimensionality()>=0, Green(), LightRed()))

Hope this works.

Re: Text Color Expression not working in totals of Straight Table

christianjmz — Thu, 01 Sep 2016 21:20:47 GMT

Thanks Sinan, but still not working...

Actually, if I put only Dimensionality()=0, the color is only in totals, but still red.

Any other suggestion? 😕

Re: Text Color Expression not working in totals of Straight Table

christianjmz — Thu, 01 Sep 2016 21:26:17 GMT

Visual cues did it!

I was trying to do it inside the expression, but this worked perfectly anyway.

Thanks Hiren!!

Re: Text Color Expression not working in totals of Straight Table

sinanozdemir — Thu, 01 Sep 2016 21:27:34 GMT

Can you post the app? or just a small portion of it at least? Well, if you want to color change to be all the expressions including the total row, then you use Dimensionality() >= 0. If you only want the total row to change, then Dimensionality() = 0.

A sample app would be helpful at this point.

Thanks

Re: Text Color Expression not working in totals of Straight Table

christianjmz — Thu, 01 Sep 2016 21:37:59 GMT

Thanks for the help Sinan,

I'd tried with both (>=0 and =0) and total remains red.

I did it with visual cues as Hiren recommended. But I will try with dimensionality too and will let you know how it's going.

Thanks for the help