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

How to show difference in pivot table

Greeting All,

Please find the attached qvw file.

Please suggest how to calculate the difference where the value of IMS and IRR in -ve.

Thanks...!!

1 Solution

Accepted Solutions
Not applicable
Author

Yeah, it works..!

We also can use columnno() instead of dimensionality().

View solution in original post

6 Replies
Not applicable
Author

Anyone??

jagannalla
Partner - Specialist III
Partner - Specialist III

What is the problem here. It is coming exactly right.

-62-62=-124 only.

Not applicable
Author

Thanks for responding..!!

It is -62- (-62)

=> -62+62

=>0

It implies the value of IMS = IRR , so the difference should be zero.

But it is not differentiating correctly on -ve values.

jagannalla
Partner - Specialist III
Partner - Specialist III

No no.. if you choose show paritial Sums it works like below

-62+(-62)

= -62-62

=-124

Not applicable
Author

It might be easier to just use 3 expressions.

Not applicable
Author

Yeah, it works..!

We also can use columnno() instead of dimensionality().