topic Re: Pivot chart expression is not working? in QlikView

Pivot chart expression is not working?

Wed, 28 Oct 2015 14:09:03 GMT

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.

Wed, 28 Oct 2015 14:49:28 GMT

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 — Wed, 28 Oct 2015 15:23:08 GMT

you can share your app please.