Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

varshavig12
Valued Contributor

Re: Script

Okay not so clear,

Example:

You have a bucket for age-group, 0-15 as small, 16-35 as adult and rest as old.

Now you want to use the above same bucket for two different charts , with one having limits like 0-2 days , 3-5 days and other as 0-2 days , 3-7 and so on ?

Partner
Partner

Re: Script

Thnks for ur post krish,bt i have alrdy created the age bucket.bt the problem is limitation.one dashboards need some limitation and other dashboards needs some limitation..bt by using same age data.

Partner
Partner

Re: Script

age.PNGhi,i have to like this for one dash boards..for other,3-7 like dt.

Re: Script

Hi,

Create 2 bucket in script .

You can not use same bucket because both bucket definition is different.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Partner
Partner

Re: Script

hi max,

i tried dt one too.if i do ths means,

ZFIFO_Ageing:

LOAD * inline [

ZFStart,ZFEnd,ZFBucket

0,2,0-2 Days

3,5,3-5 Days

6,7,6-7 days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

IntervalMatch(ZF_Age)

Load ZFStart,

     ZFEnd

Resident ZFIFO_Ageing;

ZFIFO_Ageing1:

LOAD * inline [

ZFStarts,ZFEnds,ZFBuckets

0,2,0-2 Days

3,7,3-7 Days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

IntervalMatch(ZF_Age)

Load ZFStarts,

     ZFEnds

Resident ZFIFO_Ageings;

It does not show 0-2 days limit..bcoz it appear in both script...bt i need..

Highlighted
kalyanivintha1
Contributor II

Re: Script

In both interval match functions you used the same filed (ZF_Age),check in this filed,

based on this filed only data is going to reflect.

and

in second statement your have to resident from ZFIFO_Ageing1,

but your resident from ZFIFO_Ageings;

verify this.


Thanq.

Re: Script

Hi,

are you sure your data is like is this????

You can try like this

ZFIFO_Ageing:

LOAD * inline [

ZFStart,ZFEnd,ZFBucket

0,2,0-2 Days

3,5,3-5 Days

6,7,6-7 days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

concatenate

//ZFIFO_Ageing1:

LOAD ZFStarts as ZFStart, ZFEnds as ZFEnd, ZFBuckets as ZFBucket inline [

ZFStarts,ZFEnds,ZFBuckets

0,2,0-2 Days

3,7,3-7 Days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

IntervalMatch(ZF_Age)

Load ZFStart,

     ZFEnd

Resident ZFIFO_Ageing;

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

Partner
Partner

Re: Script

yeah dt fields are same