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: 
Not applicable

Pivot chart expression is not working?

Hi,

Pivot chart expression not showing values when it is in chart but the same expression is showing values when I add into text object

below are the details in chart

dim1: ID

dim2: Log

dim3: CB

dom4: Status

expr1: Sum(Amount)

expr2: Sum(CancelledAmount)

expr3: Sum(Amount)-Sum(CancelledAmount)

expr2 is not showing values. please can anyone suggest me is there any thing wrong in expression value?

Thanks.

2 Replies
Not applicable
Author

Hi, do you have null value or zero if cancelledAmount is zero for any one of dimension values.

Chart Properties --> Presentation --> check "Show Zero Values" & "Null Value=0" & Missing value=0

Anonymous
Not applicable
Author

you  can share your   app please.