Query in Tagging

Fri, 22 May 2015 08:46:35 GMT

Hello all,

Could you please help me to sort the following problem which I face in Qlikview?

I have the following table in my qlikview application.

Region 1 has one account ABC and * indicates all the sub-accounts available in the database (say 100)

Region 2 has one account DEF and there are 2 sub-accounts B1 & B2 (out of the available say 50 sub-accounts, I take only B1 & B2 sub-accts).

Now I have to do tagging in such a way that, Region 1 picks all sub-accounts and region 2 picks only 2 sub-accts out of the available sub- accts.


Could anyone please help me on this?

Thanks in advance,

Vidhya

Re: Query in Tagging

Mon, 25 May 2015 08:32:34 GMT

It'd look something like this:

TABLE_ALL_SUBS:

LOAD Region, Account

Resident Origin

Where Sub-Account = '*';

Outer Join (TABLE_ALL_SUBS)

LOAD Distinct Sub-Account

Resident Origin;

Concatenate(TABLE_ALL_SUBS)

LOAD Region, Account, Sub-Account

Resident Origin

Where Sub-Account <> '*';

Rename TABLE_ALL_SUBS to Table_final.