topic Re: Qlikview Object Error in QlikView

Qlikview Object Error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Qlikview Object Error

vikasmahajan — Thu, 30 Jun 2016 06:57:44 GMT

try this

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

Vikas

Re: Qlikview Object Error

Anonymous — Thu, 30 Jun 2016 07:12:50 GMT

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

Re: Qlikview Object Error

nilapril2010 — Thu, 30 Jun 2016 07:44:40 GMT

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