Qlikview Object Error

[Anonymous]

Hi,

I have two objects on my sheet displaying data.  a Text box to display the number of Listed items, and a straight table displaying the items.

The formula for the straight table is as follows :

=if(DATE1>DATE2,[TU Number])

The text object displays:

=count(DISTINCT(if(DATE1>DATE2,[TU Number])))

However the number of items displayed and the count of the textbox does not relate.  I have tried using a listbox to display the same information as the straight table and it does end up listing the same information as displayed in the textbox, however i need to add an expression showcasing a different column so i cannot use a listbox.

It seems like a problem with the object itself?  Can anyone please assist in solving this problem?

Thanks in advance.

[vikasmahajan]

try this 

= sum(Aggr(If(Count([TU Number])>1 and Date1>Date2,1,0),Date1,Date2))

Vikas

[Anonymous]

Formula works perfectly.  The listbox however is still not displaying the correct information.

[nilapril2010]

In textbox, you are counting distinct values. Listbox displays distinct values only. So TextBox and ListBox result will tally. But your table expression is without Distinct keyword. So it may not tally with TextBox object.

Nilanjan