topic Re: two weeks intervalMap in QlikView

two weeks intervalMap

Tue, 30 Apr 2013 06:45:44 GMT

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

Re: two weeks intervalMap

sushil353 — Tue, 30 Apr 2013 06:51:33 GMT

Try this:

InterlvaMap:

Mapping Load * inline

[

key, label

1, 1-2

2, 3-4

3, 5-6

];

Map weekno using InterlvaMap;

tab1:

LOAD * Inline

[

weekno

];

Re: two weeks intervalMap

sushil353 — Tue, 30 Apr 2013 06:53:08 GMT

MAP label USING IntervalMap

Check your spelling with mapping table

InterlvaMap and USING IntervalMap

Re: two weeks intervalMap

Tue, 30 Apr 2013 07:02:55 GMT

firstly

you make interval by this syntax for week.

class(sum(week),1).

then try mapping

Re: two weeks intervalMap

Tue, 30 Apr 2013 07:22:15 GMT

vishwaranjan

I´m totally blank regarding your answer.

what does

class(sum(week),1).

do?

Please write some of the script.

What I´m trying to gain by the 2 weeks interval, - is how many items sold per first 2 weeks, second 2 weeks - third

2 weeks...... and so on

Re: two weeks intervalMap

Tue, 30 Apr 2013 07:22:59 GMT

My spelling in the script is ok - sorry for wrong spelling here

Re: two weeks intervalMap

Tue, 30 Apr 2013 07:43:32 GMT

the above post use for making Interval.

If your interval are already hard coaded. then try this,

InterlvaMap:

Mapping Load * inline

[

key, label

1, 1-2

2, 3-4

3, 5-6

];

Map weekno using InterlvaMap;

tab1:

LOAD * Inline

[

weekno

];

what exactly want the ouput Explain?

Re: two weeks intervalMap

Tue, 30 Apr 2013 07:47:05 GMT

I have already tried but it does nothing??

Re: two weeks intervalMap

Tue, 30 Apr 2013 07:55:37 GMT

My script now looks like this

IntervalMap:

Mapping Load * inline

[

key, label

1, 1-2

2, 3-4

3, 5-6

];

Map weekno using IntervalMap;

tab1:

LOAD * Inline

[

weekno

];

load weeknumber as twoweeks

resident [tab1];

so good so far - I can make a field twoweeks, but it doesnt filter with the rest of the datafields???

Re: two weeks intervalMap

sushil353 — Tue, 30 Apr 2013 08:43:05 GMT

Check the table viewer.. ctrl+T..

check if the table is linked with the other tables or not..

if not. then try to rename the field in such a way so that they can link with the other tables.

HTH

Sushil

Re: two weeks intervalMap

Tue, 30 Apr 2013 11:22:45 GMT

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

Re: two weeks intervalMap

sushil353 — Tue, 30 Apr 2013 11:48:43 GMT

Please post the sample app..

Re: two weeks intervalMap

Tue, 30 Apr 2013 12:25:19 GMT

file added

Re: two weeks intervalMap

sushil353 — Tue, 30 Apr 2013 12:30:38 GMT

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.

Re: two weeks intervalMap

Tue, 30 Apr 2013 12:39:18 GMT

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>

Re: two weeks intervalMap

swuehl — Tue, 30 Apr 2013 12:59:28 GMT

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

]

;

Re: two weeks intervalMap

Wed, 01 May 2013 05:16:17 GMT

exactly - thanx a lot