Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
2 Replies
simotrab
Contributor II

Re: Custom dimension in Table column

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
Contributor III

Re: Custom dimension in Table column

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