Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Pivot format


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.

3 Replies
Honored Contributor II

Re: Pivot format

Please post an example

Esteemed Contributor II

Re: Pivot format

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)

Contributor III

Re: Pivot format

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

Community Browser