Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Nefertary
New 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
Nefertary
New 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.
1 Reply
Nefertary
New 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.