Cross Table Duplicate values

[Purushothaman]

Hi Experts,

I had used Cross Table function and the fact tables load  with duplicate values. 

I am using the below expression to extract distinct values,  but It seems expression having error. 

Please help me to correct this expression:

 Anyone, Please help!!

Thank you!!

[pcv_devo · Accepted solution]

Hi Purushothaman,

First of all, you should see why you are getting duplicates in the cross table. There is probably an incident there.

In any case, the function Aggr() returns an array of values for the expression calculated over the stated dimension or dimensions. You are not indicating that dimension of grouping in your expression.

You can read more about the Aggr function in the official documentation:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/aggr.htm