topic Re: Expression error in QlikView

Expression error

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

I have to show the list of customers with more than one invoice on the same day, I am able to show that by using the below expression

if(count({<datekey={'20180601'},CustomerCode>} DISTINCT InvoiceNumber)>1, CustomerName)

I need the TotalInvoiceAmount, but if am adding this column it is showing all the customers.

tripatirao — Mon, 26 Mar 2018 09:29:39 GMT

Do you wants to customer name in expression or dimension

are you using pivot table

and y are entering hard coding date.

Please elaborate ur requirement, it would be better if you provide the sample data

Anonymous — Mon, 26 Mar 2018 10:03:43 GMT

Customer name is not must,but customer code.

Am using straight table.

The requirement is I have show an alert if any of the customer has invoiced more than once in same day(so date should be vtoday) after every reload.

shiveshsingh — Mon, 26 Mar 2018 10:29:05 GMT

Try in below format

=aggr(if(count({<datekey={'20180601'}>} DISTINCT InvoiceNumber)>1, CustomerCode),CustomerCode)

Anonymous — Mon, 26 Mar 2018 10:35:48 GMT

I need the totalinvoiceamount for this customers.

sum(aggr(if(count({<datekey={'20180601'}>} DISTINCT InvoiceNumber)>1, CustomerCode),CustomerCode,TotalInvoiceAmount))

shiveshsingh — Mon, 26 Mar 2018 10:37:32 GMT

Can you share your app?

Anonymous — Mon, 26 Mar 2018 10:54:42 GMT

Sorry I cannot share the app. These are the two customers having more than one invoice, but total invoice amount is 0

sasiparupudi1 — Mon, 26 Mar 2018 11:38:23 GMT

May be try

Sum({1}(Aggr(sum({1} InvoiceAmount),CustomerCode))

or post some sample data

Anonymous — Mon, 26 Mar 2018 11:54:20 GMT

try this ...

if(sum(aggr(count(distinct InvoiceNumber), CustomerCode, InvoiceDate)) > 1,

sum(aggr(count(distinct InvoiceNumber), CustomerCode)) )

Anonymous — Mon, 26 Mar 2018 12:13:44 GMT

I have added invoice amount. It should show A and C only but now showing all the three customers.

sasiparupudi1 — Mon, 26 Mar 2018 12:29:31 GMT

Change the expression to

If(Column(1)>=2,sum(TotalInvoiceAmount))

If(Count>=2,sum(TotalInvoiceAmount))