Showing Incorrect Average for the column in Staright table.

neha_shirsath — Wed, 31 Oct 2018 07:35:51 GMT

Hi Folks,

I'm facing issue in showing incorrect average for columns highlighted in below image.

I'm using below expression for 1st column calculation and this is giving correct avg for 1st column but not for other -

=if(dimensionality()=1,Avg(Aggr(count({<[FileType]={"Opportunities"}, [Opportunity Lifecycle Status]={'Open'}>} distinct [Opportunity ID]), [Sales Enginner Description])),
Count({<[FileType]={"Opportunities"}, [Opportunity Lifecycle Status]={'Open'}>} DISTINCT [Opportunity ID]))

Thanks in advance.

-Neha

Re: Showing Incorrect Average for the column in Staright table.

jonathandienst — Wed, 31 Oct 2018 08:03:40 GMT

I suggest that a small QVW flle to illustrate the problem. The data does have to be "real", but the data model should be representative. In addition outline the expected amount and the calculation required. The expression you posted is useful, but not enough.

topic Re: Showing Incorrect Average for the column in Staright table. in QlikView

Showing Incorrect Average for the column in Staright table.

Re: Showing Incorrect Average for the column in Staright table.