topic Show value in an expression in QlikView

Show value in an expression

Tue, 04 Sep 2012 12:17:32 GMT

I used the following formula but it isn't working as i hoped it would be:

if((sum(_namefield)/sum(_namefield))<0.3,Red(),Black())

I want all values <0.3 to be in red but nothing is happening when i use the formula above.

Someone knows haw to solve my problem?

rajni_batra — Tue, 04 Sep 2012 12:19:59 GMT

sum(_namefield)/sum(_namefield)

i think u have mistaken it will return always one i think it should be

sum(_namefield)/total sum(_namefield)

Tue, 04 Sep 2012 12:29:25 GMT

Maybe i should have been more clear.

The first 'namefield' isn't the same as the second.

Lets assume the first one is 10 and the second one is 100

Take the formula above into account and the result should be 0,10 and should turn red of course.

That last part isn't happening.

Do you need more info?

Miguel_Angel_Baeyens — Tue, 04 Sep 2012 12:30:30 GMT

Hi,

The expression you wrote will always return "1", because it is always dividing the value of each cell into itself. You might mean

=if(sum(_namefield) / sum(TOTAL _namefield) < 0.3, Red(), Black())

That will divide the value in each cell by the value of the entire column.

Hope that helps.

Miguel

rajni_batra — Tue, 04 Sep 2012 12:30:59 GMT

can u post demo values

whiteline — Tue, 04 Sep 2012 12:40:21 GMT

svangrimbergen,

Your sums are the same.

I understand that you expects something different but don't understand what.

Could you discribe, where you use this expression and what result you want to achieve.

sreenivas — Tue, 04 Sep 2012 12:52:38 GMT

if(Sum(_namefield)/Above(Sum(_Namefield) < 0.3, Red(), Black())

whiteline — Tue, 04 Sep 2012 14:33:22 GMT

=if(Sum(_namefield)/Above(Sum(_Namefield)) < 0.3, Red(), Black())

Tue, 04 Sep 2012 15:04:40 GMT

Thanks Miguel. It works!