Map Items

[#1]

Hello at all friends of QV !! [:)]

I need to mapping the Item and visualizing in list box Jus the Item with a one value.

In the example exists a items undefined so when the item is undefined need to write 'undefined' ;

item:
Load * inline [
item , family
item2 , family1
item12 , family1
item15 , family1
item20 , family2
item22 , family2
item25 , family2
item30 , family3

];

fam:

join Load * Inline [
family , line
family1 , line1
family2 , line2
family3 , line3

];

myValue:

Load * inline [
item , qty, amount

item2 , 10, 100
item3, 40, 400
item20 , 60, 80
item400, 80, 90
];

thanks, best regards

Sl

[Anonymous]

This is one possible sollution:

item:
Load * inline [
item , family
item2 , family1
item12 , family1
item15 , family1
item20 , family2
item22 , family2
item25 , family2
item30 , family3

];

fam:

join Load * Inline [
family , line
family1 , line1
family2 , line2
family3 , line3

];

myValue:

Load * inline [
item , qty, amount

item2 , 10, 100
item3, 40, 400
item20 , 60, 80
item400, 80, 90
];
// Extra code :
Left Join (myValue) Load * Resident item;
NewValue:
Noconcatenate Load
 item,
 if(IsNull(family), 'undefined', family) as family,
 if(IsNull(line), 'undefined', line) as line,
 qty,
 amount
Resident myValue;
Drop table myValue;
Drop table item; // in this case
Drop table fam; // in this case

Also take a look in the QlikView Help pages at Mapping Load and the ApplyMap() (especially the 3th parameter) function.

[#3]

but the mapping and the apply oesn'work correctly

I need the Applications shows the list box GUST with the item, family and line true and, when item ir family or lineare false ( not prenet in master) the list

Im interested to a mapping load and Apply load ...I tryed but doesn't work correctly.

If you could suggest a script by mapping load..

Thanks, nest regards

--

Slash

[Anonymous]

If you could post your try with the ApplyMap function, it would be easier to comment on what you need to change in your code.

[#5]

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='€ #.##0,00;-€ #.##0,00';
SET TimeFormat='h.mm.ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY h.mm.ss[.fff]';
SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';
SET DayNames='lun;mar;mer;gio;ven;sab;dom';


item:
Load * inline [
item , family
item2 , family1
item12 , family1
item15 , family1
item20 , family2
item22 , family2
item25 , family2
item30 , family3

];

fam:

join Load * Inline [
family , line
family1 , line1
family2 , line2
family3 , line3

];

myValue:

Load * inline [
item , qty, amount

item2 , 10, 100
item3, 40, 400
item20 , 60, 80
item400, 80, 90
];

myMap:

mapping Load distinct
item as it ,
family as f
resident item;


load
item,
ApplyMap('myMap' , item) as fam
resident myValue;

[#6]

some help ?

Thanks, Best Regards,

Slash