Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kkarlste
Creator
Creator

Don't show o0 rows and null or - rows pivot table

Hi this is problem

kkarlste_0-1697013156523.png



And column

kkarlste_1-1697013281180.png


And measure is this
sum (OvertimeHoursByEventDate)

kkarlste_2-1697013426909.png

 








Labels (4)
1 Reply
Chanty4u
MVP
MVP

try this

alt(sum(OvertimeHoursByEventDate),0)

then uncheck "include zero values" option