Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nefertary
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

Labels (1)
1 Solution

Accepted Solutions
Nefertary
Contributor II
Contributor II
Author

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

View solution in original post

1 Reply
Nefertary
Contributor II
Contributor II
Author

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