topic Map Items in QlikView

Map Items

Sat, 27 Jun 2009 19:12:57 GMT

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

Map Items

Anonymous — Sun, 28 Jun 2009 20:07:28 GMT

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.

Map Items

Sun, 28 Jun 2009 21:05:00 GMT

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

Map Items

Anonymous — Sun, 28 Jun 2009 22:41:20 GMT

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.

Map Items

Mon, 29 Jun 2009 02:10:14 GMT

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;

Map Items

Tue, 30 Jun 2009 01:06:53 GMT

some help ?

Thanks, Best Regards,

Slash