topic Re: Pivot Table Dimension Condition Format in QlikView

Pivot Table Dimension Condition Format

Anonymous — Tue, 22 Mar 2016 15:48:59 GMT

Hello,

I'm a beginner on QlikView, and I would modify my Pivot Table format with conditions on dimensions.

Here is the pivot table on QlikView:

And the Excel:

Do you have an idea ? For example for the forecolor of the partial sum named "Total Staff" ?

Thank you in advance for your help,

Cocalero.

Re: Pivot Table Dimension Condition Format

Chanty4u — Wed, 23 Mar 2016 05:15:51 GMT

can u explain more?

u want to modify the table format means?

if yes in style tab there is current style ----> drop down u can select there.

if not explain?

Re: Pivot Table Dimension Condition Format

Anonymous — Wed, 23 Mar 2016 05:38:39 GMT

Do you want to display Total as Total Staff ? if it is the case go to Presentation tab and give your desired name in the

Labels for Totals

Re: Pivot Table Dimension Condition Format

tamilarasu — Wed, 23 Mar 2016 05:49:27 GMT

Hi,

You can use dimensionality() in your text expression like below.,

If(Dimensionality()=0,RGB(28,75,240))

Re: Pivot Table Dimension Condition Format

Chanty4u — Wed, 23 Mar 2016 05:54:41 GMT

If u want to chnge the colurs based on dimensions or epxresions

as tamil said use dimenionality() or

u can use custom format cell also.

go to -->view---> design grid--->

select ur table --->right clik---> custom format cell----> select ur columns or rows----->and select colur and apply.

Re: Pivot Table Dimension Condition Format

avinashelite — Wed, 23 Mar 2016 06:00:43 GMT

if you want the Total to have different color than you could use the Dimensionality() function

Go to > expression > you will see + mark >click on it you will the background color option > paste the expression

If(Dimensionality()=0,blue())

To change the Label header color then > click on design grid from the design tool bar > right click on the label header > custom format cell > and the color you want

Re: Pivot Table Dimension Condition Format

Digvijay_Singh — Wed, 23 Mar 2016 06:01:06 GMT

Just right click on table and use Custom cell option.

Re: Pivot Table Dimension Condition Format

Wed, 23 Mar 2016 07:09:55 GMT

Give a right click on report and then---> custom format cell----> select your columns or rows--->select your desired color and apply.

Re: Pivot Table Dimension Condition Format

Anonymous — Wed, 23 Mar 2016 08:55:25 GMT

Sorry, but i don't see this option and my table. I have:

Re: Pivot Table Dimension Condition Format

Chanty4u — Wed, 23 Mar 2016 10:06:22 GMT

chk dis

or else go to view tab there u will find grid view option clik on that

Re: Pivot Table Dimension Condition Format

Anonymous — Wed, 23 Mar 2016 10:09:38 GMT

Thanks a lot, it works !

Re: Pivot Table Dimension Condition Format

settu_periasamy — Wed, 23 Mar 2016 10:29:04 GMT

Hi,

check this..

Custom formatting table cells - The Qlik Fix! The Qlik Fix!

Re: Pivot Table Dimension Condition Format

Wed, 23 Mar 2016 10:58:51 GMT

Hi Sebastien,

Please find attached Word document Cell Color Changes.

In this document i have mention all steps how to change the cell color.

I think it may be help you.

Re: Pivot Table Dimension Condition Format

avinashelite — Wed, 23 Mar 2016 11:43:51 GMT

If you have got the answer mark the helpful and correct answers