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: 
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.