Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Color Of Fields

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

10 Replies
Not applicable

Color Of Fields

Try this if it works:

Go to User Preferences.

In Objects Tab:

'Tick'  the ignore calculation Limits Checkbox.

chauhans85
Esteemed Contributor

Color Of Fields

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

Not applicable

Re: Color Of Fields

Hi Sunil,

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

Not applicable

Re: Color Of Fields

Hi Erika,

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

I am using qlikview10.

Thanks.

chauhans85
Esteemed Contributor

Color Of Fields

please  share the samplee

Not applicable

Color Of Fields

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

Not applicable

Re: Color Of Fields

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.

Not applicable

Re: Color Of Fields

Then how can I able to do it on Qlikview10.

Not applicable

Re: Color Of Fields

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

Community Browser