topic Re: Aggregation functions in noconcatenate load in QlikView

Aggregation functions in noconcatenate load

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

Hello, how can I perform aggr operations in noconcatenate load? While using edit expressions, I am getting error (you have attempted to apply numerical expression, which is not uniquely defined for specific variable). Thank you!

Re: Aggregation functions in noconcatenate load

sunny_talwar — Mon, 03 Dec 2018 15:13:45 GMT

Do you want to share what are you trying? may be share images or a sample to elaborate on your issue?

Re: Aggregation functions in noconcatenate load

Matt — Mon, 03 Dec 2018 15:55:48 GMT

I have two tables with same structure and I want to perform, f.e. count of name (customers) from second table. Can I use alias like in SQL? I now that I can use FieldCounter, but want to learn how to deal with these issue in noconcatenate load

Data:
LOAD

ID,

Name,

[Business segment],

[Estimated Amount]

FROM

ABD;

Orders:
NOCONCATENATE

LOAD

ID,

Name,

[Business segment],

[Estimated Amount]

FROM

ABC;

Re: Aggregation functions in noconcatenate load

sunny_talwar — Mon, 03 Dec 2018 16:09:57 GMT

Would you be able to demonstrate this with a few rows of data as to what exactly are you trying to do? or can you show what exactly you would handle this in your sql?

Re: Aggregation functions in noconcatenate load

rwunderlich — Tue, 04 Dec 2018 03:34:08 GMT

To count you'll need to use a count() and a group by:

CustomerCount:
Load count(Distinct Name) as CustomerCount
From ABC
Group by Name;

-Rob

Re: Aggregation functions in noconcatenate load

Matt — Tue, 04 Dec 2018 09:21:40 GMT

Can I somehow manage this in edit expressions?

Re: Aggregation functions in noconcatenate load

Matt — Tue, 04 Dec 2018 10:15:29 GMT

Let's say my edit script looks like this and I want to create pie chart with information about favourite color (dimension color and count(name) ??) but only from second table. I want to do this in edit expression, not in edit script mode. Is it possible?

Re: Aggregation functions in noconcatenate load

sunny_talwar — Tue, 04 Dec 2018 11:55:29 GMT

but you mentioned noconcatenate load? where you do you see edit expressions in the script?

Re: Aggregation functions in noconcatenate load

Matt — Tue, 04 Dec 2018 12:11:22 GMT

Edit expressions while building a chart

Re: Aggregation functions in noconcatenate load

sunny_talwar — Tue, 04 Dec 2018 12:13:44 GMT

Then use Count(DISTINCT Name)... I mean I am not even sure what you have and what you are looking to get... you have been very vague... do you have a sample you can share?