Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom dimension in Table column

Hi all,

How can i use the field of different tables as dimension in table.

I need to have the first column of table as,

delivered,

opened,

from EMAILMETRICS table.

`landing_page_hits`,

    `sign_up`,

    completions from CAMPAIGNMETRICS  table.



Header 1Header 2Header 3
Delivered
Opened
landing_page_hits
signup
completions


LOAD `campaign_metrics_id`,

    `email_type_id` as metrics_email_type_id,

    sent,

    delivered,

    bounced,

    opened,

    clicks,

    unsubscribes,

    deferred;

SQL SELECT `campaign_metrics_id`,

    `email_type_id`,

    sent,

    delivered,

    bounced,

    opened,

    clicks,

    unsubscribes,

    deferred

FROM EMAILMETRICS;

LOAD `batch_meta_data_id`,

    `landing_page_hits`,

    `sign_up`,

    completions,

    fails,

    partials,

    num_required_subjects;

SQL SELECT

   `batch_meta_data_id`,

    `landing_page_hits`,

    `sign_up`,

    completions,

    fails,

    partials,

    num_required_subjects

FROM CAMPAIGNMETRICS ;

Thanks,

Kumar

2 Replies
simotrab
Creator III
Creator III

Hi!

Maybe you could try to use the CrossTable function with the Concatenate function.

Here probably something helpful:

The Crosstable Load

The idea is to concatenate two different CrossTable

Here a simple example:

crosstable(header1,header2)

load

dim1,

dim2,

dim3,

dim4,

....

sql select

...

FROM EMAILMETRICS

group by

....;

concatenate

crosstable(header1,header2)

load

dim1,

dim2,

dim3,

dim4,

....

sql select

...

FROM CAMPAIGNMETRICS

group by

....;

pljsoftware
Creator III
Creator III

Hi Kumar,

you can create a inline table

NewTable:

LOAD * INLINE [

    Header1, Header2, Header3

    delivered, ,

    opened, ,

    landing_page_hits, ,

    sign_up, ,

    completions, ,

];

and if you want to user it in a Pivot table or other chart you can use Set Analysis to get related data.

Best Regards

Luca Jonathan Panetta