Re: Format row on pivot chart - Qlik Community

Report Inappropriate Content · ‎2014-10-30

Hello everyone,

I have pivot chart which show sum(amount) per month for certain position. I colored particular position (put some code in Background property of field or expression), but some cells were left uncolored, because there's no transaction in that month (picture below). How can I color that field?

Tnx

its_anandrjs · ‎2014-10-30

Consider Null conditions in the code also that you use in the Background or you can use visual cues also from chart properties >> Visual cues.

Regards

Anand

PrashantSangle · ‎2014-10-30

Hi,

In your expression write code for null field also.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-10-30

I try but it wont color cell. Maybe I need some virtual transaction for that month.

Report Inappropriate Content · ‎2014-10-30

I try but it wont color cell. Maybe I need some virtual transaction for that month.