topic Groups in QlikView

Groups

evansabres — Wed, 22 Feb 2017 20:14:53 GMT

I have three fields in my script, each from different data files / tables:

webPLTFRM (all records are 'Web')

mblPLTFRM (all records are 'Mobile')

appPLTFRM (all records are 'App')

Ultimately, I want to have a list box where the user can select either 'Web' 'Mobile' or 'App'

My tables are already joined by a date field. (DTE) so if I re-name the field above to a common name such as PLTFRM I get an error in my script.

Any suggestions on how to script this better or create this group in my application?

Re: Groups

sunny_talwar — Wed, 22 Feb 2017 20:33:29 GMT

May be create a flag for each table:

webPLTFRM :

LOAD YourFields,

'Web' as Flag

FROM webPLTFRM;

mblPLTFRM:

LOAD YourFields,

'Mobile' as Flag

FROM mblPLTFRM;

and so on....

Re: Groups

evansabres — Wed, 22 Feb 2017 20:37:30 GMT

This is currently how my script reads. (DTE is the linking field between all three tables) Where would I place the 'Flag'??

WEB:

LOAD

PlatformID AS webPLTFRM,

Date AS DTE,

MONTH(Date) AS MNTH,

YEAR(Date) AS YEAR,

[Monthly Unique Visitors] AS webUNQVSTRS,

[Total Visitors] AS webTTLVSTRS,

[Page Views] AS webPGVWS

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Mobile:

LOAD

PlatformID AS mblPLTFRM,

Date AS DTE,

[Monthly Unique Visitors] AS mblUNQVSTRS,

[Total Visitors] AS mblTTLVSTRS,

[Page Views] AS mblPGVWS

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

App:

LOAD

PlatformID AS appPLTFRM,

Date AS DTE,

[Monthly Unique Visitors] AS appUNQVSTRS,

[Total Visitors] AS appTTLVSTRS,

[Page Views] AS appPGVWS

FROM(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Groups

sunny_talwar — Wed, 22 Feb 2017 20:43:40 GMT

If I were you, I would probably concatenate them into one table without renaming them and then use my Flag to differentiate between the three data types:

WEB:

LOAD

PlatformID,

Date AS DTE,

[Monthly Unique Visitors],

[Total Visitors],

[Page Views],

'Web' as Flag

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Mobile:

Concatenate(WEB)

LOAD

PlatformID,

Date AS DTE,

[Monthly Unique Visitors],

[Total Visitors],

[Page Views],

'Mobile' as Flag

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

App:

Concatenate(WEB)

LOAD

PlatformID,

Date AS DTE,

[Monthly Unique Visitors],

[Total Visitors],

[Page Views],

'App' as Flag

FROM(txt, codepage is 1252, embedded labels, delimiter is ',', msq);