topic Re: Custom Banding in Pivot Table in QlikView

Custom Banding in Pivot Table

sampada0810 — Wed, 16 Nov 2016 07:43:46 GMT

Hi All,

I want to have custom banding in Pivot Table.

I have 3 dimensions and some 5-6 expressions.

Please find the below screenshot:

For Pivot table, I tired using "If(Even(RowNo(),RGB(249,249,249))" in Background Colour of Expressions and Dimensions. It works fine there.

But I do have a fast change option on this grid, so when I am changing this table to Straight table, I am losing the sorting functionality of the straight table.

I want to have custom banding and also don't want to lose the Sorting functionality.

What is the best possible way to achieve this?

Re: Custom Banding in Pivot Table

Anonymous — Wed, 16 Nov 2016 07:48:28 GMT

Hi,

If they require different setups and sorting I will suggest using two charts and show\hide variable to switch between the charts. Use a button or text box that changes the variable which in turn changes the chart that is visible.

Hopefully this helps you.

Re: Custom Banding in Pivot Table

sampada0810 — Wed, 16 Nov 2016 11:34:25 GMT

If I go with this approach,

the issue I am facing is:

when I expand all the dimensions in Pivot Table, I am getting distorted formatting.

Please find the image below:

Can I get rid of this?