Issue with straight table

Wed, 13 Jun 2012 07:32:05 GMT

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

Re: Issue with straight table

deepakk — Wed, 13 Jun 2012 07:52:14 GMT

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

topic Issue with straight table in QlikView

Issue with straight table

Re: Issue with straight table