Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

why the zero data shows in pivot table but not showing in a straight table and line chart?

Hi Guru,

 

Any one can help on this chart? below line chart doesn't show week 1 value (which should be zero)

Capture22.PNG

 

If I switch it to pivot table, it will show the week 1 value. Why???

Capture333.PNGHere is the expression: so basically I compare each week value increase % or decrease % against week 1 value.

Capture32.PNG

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Re: why the zero data shows in pivot table but not showing in a straight table and line chart?

I have figured out why... Need to untick suppress zero value in the presentation tab.

View solution in original post

1 Reply
Highlighted
Contributor II
Contributor II

Re: why the zero data shows in pivot table but not showing in a straight table and line chart?

I have figured out why... Need to untick suppress zero value in the presentation tab.

View solution in original post