QlikView App Dev

[ashis]

Hi,

I have a calculated dimension like the following

aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

I want to print negative value in Red. so in text color I put the below code

if(  aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB)))<0,RGB(255,0,0),black()

As a result I am getting some negative value as red and some negative value are not in red. This is very strange .

Even if I put NUM function before the aggr the result is same.

Any help much appreciated.

[Anil_Babu_Samineni]

That means, You have only -Ve values not the +ve values

[jyothish8807]

Hi Ashis,

Are you trying this in a straight table ? If so then make it an expression:

Dimension 1: AAA

Dimension 2: BBB

Expression:  aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

for text color: if(Sum(Aggr(Sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))<0,RGB(255,0,0),Black())

[ashis]

No , I am using in a pivot table.

[jyothish8807]

No problem. The same goes in case of pivot also.

can you please share what is your dimension and expressions ?

Br,

KC

[Anil_Babu_Samineni]

And do you have any cyclic Group / Drill down??

[ashis]

Hi Jyothish,

Following are my calculated dimension and expression for text color.

dimension =aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

text color=if(  sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))))<0,RGB(255,0,0),black()

[ashis]

Yes in this chart I have one drill down .

[Anil_Babu_Samineni]

I think this makes wrong?

[jyothish8807]

Hi Ashis,

Try to convert this dimension into expression and use the same text color condition.

Br,

KC

[ashis]

Hi Jyothish,

If I convert the dimension into expression and use the same text color condition , it is working fine.

However my need is to display as dimension.