topic Re: Concatenation for Measures in Direct query for Postgresql in QlikView

Concatenation for Measures in Direct query for Postgresql

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

Hi All,

As per heading of the discussion, I want to concatenate string values in two different columns of Measures in Direct Query.

How Can I achieve the same.

I am using Postgresql.

I am using -

DIRECT QUERY

DIMENSION

1 As Flag

MEASURE

col1,

col2,

col3

From demo;

And I want something like -

DIRECT QUERY

DIMENSION

1 As Flag

MEASURE

col1,

col2 || col3 as test

From demo;

Please assist.

Thanks & Regards,

Re: Concatenation for Measures in Direct query for Postgresql

adamdavi3s — Tue, 25 Oct 2016 09:35:38 GMT

Can you preceeding load a direct query?

Load *,col2 & col3 as test;

DIRECT QUERY

DIMENSION

1 As Flag

MEASURE

col1,

col2,

col3

From demo;

Re: Concatenation for Measures in Direct query for Postgresql

Anonymous — Tue, 25 Oct 2016 09:36:42 GMT

I tried this, it says, col2 not found, throws an error.

Re: Concatenation for Measures in Direct query for Postgresql

adamdavi3s — Tue, 25 Oct 2016 09:41:41 GMT

sack off the direct query and just use normal SQL?

I never really understood the benefit of direct query myself

Re: Concatenation for Measures in Direct query for Postgresql

Anonymous — Tue, 25 Oct 2016 10:57:13 GMT

anyone please assist

Re: Concatenation for Measures in Direct query for Postgresql

adamdavi3s — Tue, 25 Oct 2016 11:07:30 GMT

Sorry I was being serious, I don't think you can expect to achieve this using DIRECT Query as it doesn't give you this kind of flexibility

Re: Concatenation for Measures in Direct query for Postgresql

Anonymous — Tue, 25 Oct 2016 11:11:54 GMT

I have to use Direct Discovery approach only

Re: Concatenation for Measures in Direct query for Postgresql

sunny_talwar — Tue, 25 Oct 2016 11:12:54 GMT

Can you try this:

DIRECT QUERY

DIMENSION

1 As Flag

MEASURE

col1,

NATIVE(col2 || col3) as test

From demo;

Re: Concatenation for Measures in Direct query for Postgresql

sunny_talwar — Tue, 25 Oct 2016 11:16:20 GMT

Here are some example of how NATIVE is used. It basically allows you to do SQL manipulations to the Direct Discovery

What is QlikView Direct Discovery – Learn QlikView

Re: Concatenation for Measures in Direct query for Postgresql

sunny_talwar — Tue, 25 Oct 2016 11:17:27 GMT

Forgot to add single quotes....

DIRECT QUERY

DIMENSION

1 As Flag

MEASURE

col1,

NATIVE( 'col2 || col3' ) as test

From demo;

Re: Concatenation for Measures in Direct query for Postgresql

Anonymous — Tue, 25 Oct 2016 11:17:38 GMT

It throws an error while Reloading saying -

No Direct statement

Re: Concatenation for Measures in Direct query for Postgresql

sunny_talwar — Tue, 25 Oct 2016 11:18:36 GMT

Made a mistake earlier, try it with single quotes within the Native function

Re: Concatenation for Measures in Direct query for Postgresql

Anonymous — Tue, 25 Oct 2016 11:23:04 GMT

The example is for Dimension, I want to use the same for Measures.

I am using Postgresql, and when we use the same syntax, it throws an error

Re: Concatenation for Measures in Direct query for Postgresql

sunny_talwar — Tue, 25 Oct 2016 11:28:35 GMT

I see no documentation where it says that you cannot use NATIVE in Measures. But there is no way for me to test this because I don't have access to Direct Discovery application. But just so we are sure, did you add single quotes around your function?

NATIVE( 'col2 || col3' ) as test

Re: Concatenation for Measures in Direct query for Postgresql

Anonymous — Tue, 25 Oct 2016 11:29:35 GMT

Thanks sunny,

The reload was successful, but in the Table when I fetch the test column, it says -

"direct query failed"

Any inuts

Re: Concatenation for Measures in Direct query for Postgresql

Anonymous — Tue, 25 Oct 2016 11:33:41 GMT

Thanks sunny,

The reload was successful, but in the Table when I fetch the test column, it says -

"direct query failed"

Any inuts