Concatenation for Measures in Direct query for Postgresql

[Anonymous]

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,

MK

[adamdavi3s]

Can you preceeding load a direct query?

Load *,col2 & col3 as test;

DIRECT QUERY

DIMENSION

  1 As Flag

MEASURE

  col1,

  col2,

  col3

From demo;

[Anonymous]

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

[adamdavi3s]

sack off the direct query and just use normal SQL?

I never really understood the benefit of direct query myself

[Anonymous]

anyone please assist

[adamdavi3s]

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

[Anonymous]

I have to use Direct Discovery approach only

[sunny_talwar]

Can you try this:

DIRECT QUERY

DIMENSION

  1 As Flag

MEASURE

  col1,

  NATIVE(col2 || col3) as test

From demo;

[sunny_talwar]

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

[sunny_talwar]

Forgot to add single quotes....

DIRECT QUERY

DIMENSION

  1 As Flag

MEASURE

  col1,

  NATIVE( 'col2 || col3' ) as test

From demo;