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

How to bring the other table information through a conditional

Good Morning,

I have the following problem:

I have a table with payments among other variables, and I am calculating the difference of the current payment - previous payment $ (vVlPago) - BEFORE ($ (vVlPago)).

Where this difference was different from zero, I would just bring this line.

This could be in another table.

Does anyone know how to solve?

  1. Thanks.
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

When I took the values ​​equal to zero ...

tirar zero.png

The Qlik still bore values ​​equal to zero. That's because there was a very small value.

Example: 0.000000001


To correct this error, I used the "round".

round.png

Problem solved.


View solution in original post

5 Replies
robert_mika
Master III
Master III

Maybe this is a way:

On Presentation tab is your Suppress ZeroValues box ticked off?

Anonymous
Not applicable
Author

It does not solve.


tks.

robert_mika
Master III
Master III

Post your data, screenshot or app...

Anonymous
Not applicable
Author

Erro Qlik.PNG

Anonymous
Not applicable
Author

When I took the values ​​equal to zero ...

tirar zero.png

The Qlik still bore values ​​equal to zero. That's because there was a very small value.

Example: 0.000000001


To correct this error, I used the "round".

round.png

Problem solved.