Color Of Fields

[#1]

Hi All,

I have used straight table to bulid the report. I need to set the color for each filed when it is null.

So, I have used this expression for every individual fields " if(isNull(orgcode,red(),white()); if(isNull(orgname,red(),white() and so on...... "

It performs fine. But it affects the Performance. Most of the time it is showing "Out of virtual memeory, Allocated memory exceeds."

Please Suggest.

Many Thanks,

Sandeepa

[#2]

Try this if it works:

Go to User Preferences.

In Objects Tab:

'Tick'  the ignore calculation Limits Checkbox.

[SunilChauhan]

go to expression -> click on + sign before expression

->text color or background color( which u want)-> write the below expression

if(isNull(orgcode)=-1,red(),white())

if(isNull(orgname)=-1,red(),white())

and so on...... "

hope this heelps

[#4]

Hi Sunil,

I have done this only.. But by executing it's giving allocated memory exceeds and all. It is causing performance issue.

[#5]

Hi Erika,

I can't see this(User preference->Object->ignore calculation Limits Checkbox) option.

I am using qlikview10.

Thanks.

[SunilChauhan]

please  share the samplee

[#7]

Ok...its a bug in Qlikview 10...u won't be able to see 'Ignore calculation limits chechbox'.

[#8]

Hi Sunil,

I am unable to upload that .qvd file.

I have used that expression on each field. So, while executing it, it goes out of memory.

Can't we use this expessions on the table level.

[#9]

Then how can I able to do it on Qlikview10.

[#10]

Hi Sandeepa,

Are you sure that the color is causing the out of memory issue?

What happens if you have no definition for the color?

How many records do you have in the table? How much memory do you have available in your PC running the report?

Regards,

Bert