Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Blank Column in Pivot Table

Hi all,

I have manage to do Blank Column in Pivot Table using Expression ' ' (Space) and

Background & Text Color = RGB(224,224,224) that's fine.

But now I want heading for this Blank Column invisible or greyed out with same colour like RGB(224,224,224).

How to do?

I also want Blank rows after each Total.

Please help!

Blank Column in Pivot.PNG.png

12 Replies
Partner
Partner

Re: Blank Column in Pivot Table

Can you extra rows in the script for every Reg No, with Brach etc defined as ''?

Example:

Concatenate

Load Distinct

Reg No,

'' as Branch,

Resident fact

Bert

Not applicable

Re: Blank Column in Pivot Table

Hi Bert,

Thank for reply but I can't do in script side because I got daily sale transaction linked with other tables.

Is there any thing can I do on report/Pivot table?

Vinay


Not applicable

Re: Blank Column in Pivot Table

Hi all,

Any Help from Qlikview Guru's?

Please help me out.

Vinay


Re: Blank Column in Pivot Table

Hi,

I am not sure is this as per your requirements,

but what I understand with you statement

"

now I want heading for this Blank Column invisible or greyed out with same colour like RGB(224,224,224).

"

just go to the chart property->

visual cues->select expression ->then at bottom you can see Text option->in front of that you can select text color and background color.

Hope this will help you with your first requirements.

Regards,

PS

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Blank Column in Pivot Table

Hi Max,

Thank for reply but this is not my requirement.

I want to change colour of Column Heading For this Blank Column.(See in picture with Red Circle).

Regards

Vinay


Re: Blank Column in Pivot Table

Hi,

That heading  is nothing but your values come from dimension or from expression

if it is dimension values

then go to

dimension tab->select dimension->click on plus sign->set background and text color

as per your requirements

if it is expression the you have same functionality in expression tab.

Hope this will solve your problem.

Regards,

PS

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Blank Column in Pivot Table

Hi max,

see attached pict with Dimension and Expression.

In sort I want a GAP between Qty and Calls Column.

Blank Column in Pivot2.png


Re: Re: Blank Column in Pivot Table

Hi,

find attached application

where ever you are creating blank dimension

change there text color and background color to gray.

check enclosed file and if possible share your qvw.

Regards,

PS

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Blank Column in Pivot Table

Is this what ur looking for? Capture.PNG.png