two weeks intervalMap

[#1]

I´m trying to make a 2 week interval, but having trouble.

I use this but doeent work

InterlvaMap:

Mapping Load * inline[

key, label

1, 1-2

2, 3-4

3, 5-6

.................and so on

]

;

MAP label USING IntervalMap

Load

weeknumber as label

I got a field weeknumber

[#2]

the table is not linked - but if I rename it still does something wrong - I get no data at all when filtering

[sushil353]

Please post the sample app..

[#4]

file added

[sushil353]

Hi Polschou,

Your file is working fine.. it is filtering data when i am doing any selection on two week list box....

what is your issue please explain with example.

[#6]

Hi Sushil

What I need is filtering an interval of 14 days or 2 weeks

So I want to click on a field called weekpairs, consisting of numbers ex. 1 = weekno. 1 and 2 2=weekno. 3 and 4 and so on

Further on it should, when added to another script by clicking on weekpair 1 I get all items sold in the first two weeks – weekpair 2=what is sold I the weeks 3 and 4

I hope this clarify things

regards

Fra: sushil kumar

Sendt: 30. april 2013 14:31

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: two weeks intervalMap

QlikCommunity<http://community.qlik.com/index.jspa>

Re: two weeks intervalMap

created by sushil kumar<http://community.qlik.com/people/sushil353> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/340780#340780>

[swuehl · Accepted solution]

You are mapping week 1 to '1-2' and 2 to '3-4' etc. where I believe both week numbers should be mapped to '1-2'

IntervalMap:

MAPPING LOAD * INLINE [

key, twoweeks

1, 1-2

2, 1-2

3, 3-4

4, 3-4

]

;

[#8]

exactly - thanx a lot