Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with straight table

Hi All,

   I have a two straight tables where i am suppose to show the variances and Variance % with ascending and descending sort order

.I mean both the tables have same data but sorted ASEC and DESC. As i dnt want to replicate the same data in two tables have decided to show the tables (Overages - Where I will show only the variances where the value is >=0) and (Underages -- Here i would show as <0).

I am not sure why the cilck view is intoducing the new values in to the table when I put a condition to the variance >=0.All rows highlighted in red are newly added rows.

Please let me know if you have any suggestions.. Thanks in advance...

1 Reply
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

Can you attach the application. Also try the following.

Enable only the first expression and check if the new data is getting added. Try this exercise on each expression.

You will come to  know that from which field this new data is getting added.

Also check if suppress null and suppress missing is enabled. You will find it in the presentation tab.

Deepak