topic How to exluding one value in apply Map in QlikView

How to exluding one value in apply Map

Wed, 05 Nov 2014 10:55:13 GMT

Hi Friends,

I am using apply map function to recognise the sales type.

I have use three columns x ,y, z to identify which sales type it is.

So X Y Z

1 2 1

2 1 3

4 5 7

The problem is the combinations of X and Y are less. But the Z can take any value excluding ZERO (0).

So How to exclude 0 from my z value. Should I write all the values for z also. there are hundred in Numbers.

Thanks

Pavan

Re: How to exluding one value in apply Map

ali_hijazi — Wed, 05 Nov 2014 10:57:44 GMT

can you elaborate more

the mapping table should take only 2 columns

is this your mapping table or your data table?

Re: How to exluding one value in apply Map

sujeetsingh — Wed, 05 Nov 2014 10:58:39 GMT

Can you post a more detailed script.

As per my level of knowledge you can use conditional resident load after apply map

Load

X,Y,Applymap('MapTable',ID,Z) as Z

where Applymap('MapTable',ID,Z)<>0

Re: How to exluding one value in apply Map

Wed, 05 Nov 2014 11:51:09 GMT

Thanks

But I want values where only Z is not equal to Zero and ID can take any values.

Re: How to exluding one value in apply Map

puttemans — Wed, 05 Nov 2014 11:57:16 GMT

What if you concatenate X & Y first, then create the mapping table, with the addition 'where Z <> 0'

Re: How to exluding one value in apply Map

Wed, 05 Nov 2014 12:40:29 GMT

Hi Johan,

can you Please sample code

Re: How to exluding one value in apply Map

puttemans — Wed, 05 Nov 2014 12:49:50 GMT

Hi Pavan,

If your aim is to use the example you gave for mapping, then it should look like :

Map_Salestype:

MAPPING LOAD

X&'|'&Y as XY,

Z
RESIDENT (yourprevious table)

WHERE Z <> 0;

In the table where you want to use the mapping table, you then need to create the XY variable the same way before applying the map. Else it won't work.

Regards,