topic Adding an empty row in a pivot chart in QlikView

Adding an empty row in a pivot chart

Fri, 15 Apr 2011 19:13:23 GMT

Hi,

to format a pivot chart with one dimension (Amount Type) on rows and two dimensions (Year and Month) on columns I need to insert an empty row to act as a separator with fe gray background colour. For this empty row I have set a particular value for the Amount Type dimension.

Any suggests in order to add a conditioned formatted empty row, please?

Thanks

Adding an empty row in a pivot chart

Fri, 15 Apr 2011 19:31:49 GMT

Not sure your exact requirements, but how about creating an expression formula:

=''

=null()

Adding an empty row in a pivot chart

Sat, 16 Apr 2011 06:12:55 GMT

Hi,

I've partially solved by load a dummy row with fictitious values for my dimensions, but now I'd like fe to format the background of this dummy row added, without affecting the background of other rows.

Thanks

Adding an empty row in a pivot chart

rwunderlich — Sun, 17 Apr 2011 05:51:20 GMT

You should be able to do something with the Background color property in the Dimension. Click the plus next to the Amount Type dimension.

=if([Amount Type]='mydummy', grey())

Adding an empty row in a pivot chart

Sun, 17 Apr 2011 18:43:32 GMT

In the pivot chart I cannot see any background colour properties for a dimension.

Thanks

Adding an empty row in a pivot chart

rwunderlich — Mon, 18 Apr 2011 04:51:50 GMT

In the Dimensions tab of the chart properties, Click the "+" next to your dimension name. Then select "Backgound Color" and press the edit button.

Correction to my earlier example. There is no "grey()" function. Use a valid function name 🙂

Adding an empty row in a pivot chart

Mon, 18 Apr 2011 12:09:06 GMT

Ok, thanks, I've solved.