topic Re: Can I specify table name in an expression? in QlikView

Can I specify table name in an expression?

Tue, 12 Jan 2016 23:19:37 GMT

Hi All,

Just a quick question, can I specify table name in an expression?

For example if I got two tables (A and B) that all have the same column called invoice_number, and I want to specify number of invoice_number from column A only. How to do that? Should I have to load the same column twice( I means something like following in my script):

Table_A:

Load

Customer_name,

Invoice_Number,

Invoice_Number as Invoice_Number_DUP

from xxxxx.qvd (qvd)

Table_B:

Load

Sales_name,

Invoice_Number

from yyyyy.qvd (qvd)

and the expression is

Num(count( Invoice_Number_DUP),'###,###,###')

Re: Can I specify table name in an expression?

sunny_talwar — Tue, 12 Jan 2016 23:41:50 GMT

‌Without needing to duplicate you can do something like this:

Count({<Sales_name = {"=Len(Trim(Sales_name)) = 0"}>}Invoice_Number)

Count({<Customer_name = {'*?'}>} Invoice_Number)

Re: Can I specify table name in an expression?

Peter_Cammaert — Tue, 12 Jan 2016 23:52:30 GMT

Elim,

in your simplified data model you could just count the number of Customer_name. On condition that Customer_name is never NULL. Like in:

=Count(Customer_name)

Best,

Peter

[Edit] replaced Sales_name with Customer_name. We're looking at Table A.

Re: Can I specify table name in an expression?

sunny_talwar — Tue, 12 Jan 2016 23:59:09 GMT

‌I see what you mean. But i thought that was the requirement, unless I have mis-read the issue. I am on a phone device which makes things little more complicated.

Re: Can I specify table name in an expression?

Peter_Cammaert — Wed, 13 Jan 2016 00:06:33 GMT

Sorry Sunny, ignore the email. I adjusted my response. I may have misread your post.

Re: Can I specify table name in an expression?

sunny_talwar — Wed, 13 Jan 2016 00:25:07 GMT

‌Peter you don't have to apologize. I have learned so many things from you and you pointing out that something Isn't right is always a chance to learn something new from the discussion. I hope to continue learning from you and other experts, even if it comes at the cost of making mistakes .

Re: Can I specify table name in an expression?

Peter_Cammaert — Wed, 13 Jan 2016 00:32:52 GMT

Thanks Sunny.

Nevertheless, I'll be more careful next time