Expression

Ritu — Fri, 30 Aug 2019 17:44:02 GMT

I have a straight table where i need to find an exception report with multiple dimensions. Flags are being provided to me for exception report which i have used in expression.

i have got a row count of 2932 in the straight table, i need to get this row count in a text box.

if((isMissingCRMSoldTo='Y' or isMissingCRMShipTo='Y') and ignorecustomer='N' and isDuplicate='N' and isInValidDistributorCode='N' ,1,0)

I am using this above expression to do my exception report.

for getting the count of all the rows i am using

=sum(Aggr(if((isMissingCRMSoldTo='Y' or isMissingCRMShipTo='Y') and ignorecustomer='N' and isDuplicate='N' and isInValidDistributorCode='N' ,1,0),File_DistributorCode,inmarketsoldtocoderefrence,File_SoldToName,inmarketshiptocoderefrence,File_ShipToName,File_PostCode,File_Suburb,File_Region,Country,SoldToName,ShipToName,C01SOLDTO,C01SHIPTO,isMissingCRMSoldTo,isMissingCRMShipTo))

here in aggr() i am using the dimensions and sum() for getting the count.

but the row count is coming different, getting the difference of 75

can anyone help?

Re: Expression

marcus_sommer — Mon, 02 Sep 2019 13:29:20 GMT

Probably are the used dimensions not the same respectively not the right ones and/or your data aren't properly linked in the datamodel - I would check this again.

- Marcus

topic Re: Expression in QlikView

Expression

Re: Expression