topic Re: Format row on pivot chart in QlikView

Format row on pivot chart

Thu, 30 Oct 2014 12:46:30 GMT

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

Re: Format row on pivot chart

its_anandrjs — Thu, 30 Oct 2014 12:50:23 GMT

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

Re: Format row on pivot chart

PrashantSangle — Thu, 30 Oct 2014 12:51:01 GMT

Hi,

In your expression write code for null field also.

Regards

Re: Format row on pivot chart

Thu, 30 Oct 2014 13:08:48 GMT

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

Re: Format row on pivot chart

Thu, 30 Oct 2014 13:08:54 GMT

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