topic Color Of Fields in QlikView

Color Of Fields

Tue, 30 Aug 2011 06:31:30 GMT

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

Color Of Fields

Tue, 30 Aug 2011 12:20:42 GMT

Try this if it works:

Go to User Preferences.

In Objects Tab:

'Tick' the ignore calculation Limits Checkbox.

Color Of Fields

SunilChauhan — Tue, 30 Aug 2011 12:25:38 GMT

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

Re: Color Of Fields

Tue, 30 Aug 2011 14:10:01 GMT

Hi Sunil,

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

Re: Color Of Fields

Tue, 30 Aug 2011 14:19:41 GMT

Hi Erika,

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

I am using qlikview10.

Thanks.

Color Of Fields

SunilChauhan — Tue, 30 Aug 2011 17:07:23 GMT

please share the samplee

Color Of Fields

Tue, 30 Aug 2011 17:12:50 GMT

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

Re: Color Of Fields

Wed, 31 Aug 2011 07:15:28 GMT

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.

Re: Color Of Fields

Wed, 31 Aug 2011 07:16:48 GMT

Then how can I able to do it on Qlikview10.

Re: Color Of Fields

Thu, 01 Sep 2011 13:14:53 GMT

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

Re: Color Of Fields

Thu, 01 Sep 2011 13:49:15 GMT

Hello Bert,

Yeah I am pretty sure.

There are 12 fields and 2 labels(Expressions) in my report.

My PC has 3GB RAM and 160GB harddisk. Right now 45GB space is free.

Thanks

Sandeepa