Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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