topic Restricting values in dimension in QlikView

Restricting values in dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I am handling the Scenario as:

Table 1

ABC	Order status
A	Pending
A	In progress
A	Completed
B	Completed
C	Completed
A	In progress
A	Pending

Table 2

ABC	Issuencetype
A	CMO
B	RP
A	CMO
B	C&S
C	AMR
A	CMO
A	CMO

I have two tables, now i am creating a new table with dimension by only values of 'A' from Table 1 and values of 'B' and 'C' from table 2.

By using column 'ABC' with respective filters i am combining Order Status and Issuencetype as new dimension.

Please provide your suggestions.

Regards,

Ashok Ravichandran

Re: Restricting values in dimension

Chanty4u — Wed, 01 Aug 2018 12:01:34 GMT

is this?

map1:

mapping LOAD

ABC,

OrderStatus,

FROM

......tabl1

Result:

ABC,

Issuencetype,
applymap('map1', ABC,'Unknow') as NewDimension
FROM
.....

Re: Restricting values in dimension

Anonymous — Wed, 01 Aug 2018 12:12:34 GMT

Chanty,

Thanks for your comments,

Order status and Issuance type has different values, i need only A value from table 1 associated with Order status and table 2 associated with Issuance type as new dimension

Re: Restricting values in dimension

Neymar_Jr — Wed, 01 Aug 2018 13:02:20 GMT

Hi,

Try this -

NewTable:

Noconcatenate

Load * resident Table1

where ABC = 'A';

concatenate

Load ABC

,Issuencetype as [Order status]

resident Table2

where ABC <> 'A';

Drop field Issuencetype from NewTable;

Thanks,