Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Restricting values in dimension

Hi Team,

I am handling the Scenario as:

Table 1  

ABCOrder status
APending
AIn progress
ACompleted
BCompleted
CCompleted
AIn progress
APending

Table 2

ABCIssuencetype
ACMO
BRP
ACMO
BC&S
CAMR
ACMO
ACMO

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

3 Replies
Chanty4u
MVP
MVP

is this?

map1:

mapping LOAD

ABC,

     OrderStatus,    

FROM

......tabl1



Result:

ABC,

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

Anonymous
Not applicable
Author

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

Neymar_Jr
Creator II
Creator II

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,

RT