topic find not including numbers in QlikView

find not including numbers

Tue, 22 Mar 2011 08:25:50 GMT

Hello all
Im new in QV.

I faced some problem and i need your help. let me explain it bit. My table is like

name, range, code
first, 1500-3000, 2
second, 3600-5800, 4
others, , 5

I need to find this range of others and give them others code. range end in 9999.

Regards.

find not including numbers

Tue, 22 Mar 2011 08:43:21 GMT

Sorry cant get u.

U want the code between the range like 1 to 9999 ah

find not including numbers

Tue, 22 Mar 2011 09:04:52 GMT

sorry for my bad english.

example i need to find 1-1499, 3001-3599..... and give them other's values.

find not including numbers

Tue, 22 Mar 2011 10:22:04 GMT

Am i cant explain it or its really hard to do?

find not including numbers

Wed, 23 Mar 2011 09:49:41 GMT

well now i trying to use if() and peek() to find missing ranges.

find not including numbers

Wed, 23 Mar 2011 12:14:11 GMT

hello all
Im new in QV and its really give headache.

Im trying to find to missing ranges and i using this script but it seams not working.


Test4:
load if(peek(Postal_start,0)>,'1'
 ,if(peek(Postal_start,0)<>peek(Postal_start,1),peek(Postal_start,0)=peek(Postal_end,0)+1
 ,if(peek(Postal_start,1)<>peek(Postal_start,2),peek(Postal_start,1)=peek(Postal_end,1)+1
 ,if(peek(Postal_start,2)<>peek(Postal_start,3),peek(Postal_start,2)=peek(Postal_end,2)+1
 ,if(peek(Postal_start,3)<>peek(Postal_start,4),peek(Postal_start,3)=peek(Postal_end,3)+1))))) as missing_postal_start

Please correct this.

find not including numbers

Wed, 23 Mar 2011 13:31:49 GMT

Im working on this issue for 3 day now and finally i think i got answer.

The answer is in MappingRanges.qvw in Rob Wunderlich's coockbook.