Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (3)
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.