Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot chart sub total expressions clarification

In Pivot chart, I have dimension (location,item) , expressions(quantity,value). Here, I have value but quantity is zero for some items. I need to cut this value when quantity is zero. after that sub total(show partial columns - by checked) is having the total value(including value of zero quantity). So please give me suggestions.

my expression for Qunatity is == sum(PQTY-MQTY)

my expression for Value is == sum(PSTOCKVALUE-MSTOCKVALUE)

Expecting your reply.

pls help me to solve the issue

Thanks

Kumar

1 Solution

Accepted Solutions
Not applicable
Author

Please check the attachment

View solution in original post

2 Replies
Not applicable
Author

Please check the attachment

Not applicable
Author

hi

thank u very much.

its working dear.

really great.

thanks

kumar