Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Not applicable

Alignment on Null Values in Pivot Table

Hi

I have a pivot table in which label is left aligned and my data is right aligned but null values(-) is coming as left aligned.

What could be the solution?

Thanks

Saurabh

1 Solution

Accepted Solutions
Highlighted

Re: Alignment on Null Values in Pivot Table

On the Presentation tab of your Pivot Table you will see 'Null Symbol' which defaults to '-' :

  • Delete the '-'
  • Click <apply>
  • Put the '-' back in
  • Click <apply>
  • Make sure 'Data (Text)' is set right aligned

View solution in original post

3 Replies
Highlighted
Not applicable

Re: Alignment on Null Values in Pivot Table

what do u want eactly here

Highlighted
Not applicable

Re: Alignment on Null Values in Pivot Table

Hi,

In Dimension you have null values so mat be it came like that.

Plz check the dimension nullcount(DimensionField)

Highlighted

Re: Alignment on Null Values in Pivot Table

On the Presentation tab of your Pivot Table you will see 'Null Symbol' which defaults to '-' :

  • Delete the '-'
  • Click <apply>
  • Put the '-' back in
  • Click <apply>
  • Make sure 'Data (Text)' is set right aligned

View solution in original post