Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DSDD
Contributor III
Contributor III

Dual field

Dear Community,

i want to define a field in load-script as dual, expecting that with this step i may assign ordering of a field.

My try:

DSDD_0-1612279763265.png

When i display that in a table, i get

DSDD_1-1612279825970.png

 

not what i expected. When i want to define master-item, doubled categories as well

How do i achieve a working dual-assignment, WITHOUT using several IF-Conditions?

Thanks for your help

Labels (1)
1 Solution

Accepted Solutions
skamath1
Creator III
Creator III

Really not clear with your requirements. Assuming you want to sort on the cat_sales in S, M, L and XL.

You can use mapping 

MapTemp:
Mapping
Load * inline [
NameScat, NumScat
S,0
M,1
L,3,
XL,4
] ;


Load
iln as key_iln,
corp,
Dual(sales19_class,ApplyMap('MapTemp',sales19_class,0)) as cat_sales
From data 

 

View solution in original post

1 Reply
skamath1
Creator III
Creator III

Really not clear with your requirements. Assuming you want to sort on the cat_sales in S, M, L and XL.

You can use mapping 

MapTemp:
Mapping
Load * inline [
NameScat, NumScat
S,0
M,1
L,3,
XL,4
] ;


Load
iln as key_iln,
corp,
Dual(sales19_class,ApplyMap('MapTemp',sales19_class,0)) as cat_sales
From data 

 

View solution in original post