topic Re: Formatting a Pivot Table in QlikView

Formatting a Pivot Table

Mon, 22 Sep 2014 14:35:26 GMT

I need to format a pivot table with every other row shaded and can't figure out how to do it. Is it possible, and if so, how?

Re: Formatting a Pivot Table

Siva_Sankar — Tue, 23 Sep 2014 08:11:30 GMT

Hi Alissa,

Go to Settings-> User preference -> Design -> Check "Always Show design menu item". Click ok.

Now right click on your chart cell and you will find an option "Custome format cell".

From here you can change the text and background color"

See here formatting in pivot table....urgent explained with screenshots

Re: Formatting a Pivot Table

jyothish8807 — Tue, 23 Sep 2014 08:15:58 GMT

Otherwise you can change the style of the pivot table from style TAB.

Regards

Re: Formatting a Pivot Table

Wed, 24 Sep 2014 13:56:22 GMT

Hello,

Thank you for your response. But, I have a pivot table that I need every other row shaded. The response you provided allows me to shade ALL DIMENSIONS or ALL EXPRESSIONS together. It does not all for every other row. Do you have any other suggestions? Example row 1, back ground white, row 2 background gray, row 3 background white, row 4 background gray. Thank you for your help!!

Re: Formatting a Pivot Table

Wed, 24 Sep 2014 13:58:37 GMT

Hello,

Thank you for your response. I go to the Style tab and even if I pick a style that says it is striped every 1 row, it fills the entire table with the same background color. Any suggestions?

Thank you.

Re: Formatting a Pivot Table

sunny_talwar — Wed, 24 Sep 2014 14:16:50 GMT

Does this looks like something you want?

Best,
S

Re: Formatting a Pivot Table

Wed, 24 Sep 2014 14:35:41 GMT

Yes! This is what I am needing to do! How did you do this?

Re: Formatting a Pivot Table

mjayachandran — Wed, 24 Sep 2014 14:44:05 GMT

You in your chart properties -- > in Tab Dimensions --> Used Dimension section, expand the dimension you'll have 'Background color'. In this use expression like --> '=if(Odd(RowNo()),red(),white())'

You can use the same in your expression bg also

Re: Formatting a Pivot Table

Siva_Sankar — Wed, 24 Sep 2014 15:17:40 GMT

Hi Alissa,

In your chart properties, go to expression tab,click the + on expression, select background colour and write the expression =If(Even(RowNo(TOTAL)), RGB(255, 255, 255), RGB(204,204,204)).

Refer attached screenshot and qlikviewdocument for detail information. Hope it helps.

Re: Formatting a Pivot Table

Wed, 24 Sep 2014 15:23:27 GMT

This worked great!!! Thank you!

Re: Formatting a Pivot Table

Wed, 24 Sep 2014 15:23:50 GMT

This worked great! Thank you!

Re: Formatting a Pivot Table

Wed, 24 Sep 2014 15:39:26 GMT

Since you were so helpful...

Maybe you can help me with one more question...in my pivot table, I need the second column that contains no information to be gone...when I try and use this object in an excel, it puts in the blank column and does not look proper. Do you know how to get rid of this column in a pivot table? Thank you!!!

Re: Formatting a Pivot Table

Siva_Sankar — Wed, 24 Sep 2014 15:48:01 GMT

Hi Alissa,

Is the column heading you are trying to remove a Dimension or an Expression?

If it is an expression then there is no way to remove that in a Pivot table. There is a show hide radio button for a straight table, but not on a Pivot.

If it is a dimension at the top of the column, making sure you have Suppress Zero Values ticked on the Presentation tab is key.

Make sure that all values are actually zero - rather than a very small number that rounds to zero. You could alter your expression to make values that are zero (or very near) null. You will need to use an if statement to either show the result or null based on the value.

information from Steve Dark

Re: Formatting a Pivot Table

sunny_talwar — Wed, 24 Sep 2014 17:23:19 GMT

I guess you already got what you needed now

Best,