topic Re: Pivot format in QlikView

Pivot format

Anonymous — Wed, 31 May 2017 07:45:15 GMT

Hi,

I have done a pivot table in a particular format, but when I choose a some selection the format of the table is getting changed.I have attached a screen shot.

I have enabled the option of "Show all values" and Disabled the option of "Suppress zero values".But its changing..My expectation is that even if I select something, it shouldn't change. Could anyone please help me out.

Re: Pivot format

prieper — Wed, 31 May 2017 08:02:40 GMT

Please post an example

Re: Pivot format

vinieme12 — Wed, 31 May 2017 08:08:36 GMT

Modify you expression to ignore selections in fields

2 ways to do that

1) for Example, specify the fields to ignore

Count( {< Target=, field2=, .... >} YourField)

Here selections on fields Target and Field2 will be ignored

2) ignore all selections

Count({1} YourField)

Re: Pivot format

tajmohamed30 — Wed, 31 May 2017 08:10:50 GMT

increasing font size may help as I can see the line over the top disappears