topic Re: Script in QlikView

Script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

can i use same age bucket for different dashborad...with different day limits..??if so means how??????

Re: Script

varshavig12 — Thu, 22 Dec 2016 04:51:17 GMT

Can you give us an example for the same ?

Re: Script

Anonymous — Thu, 22 Dec 2016 04:55:26 GMT

Hi sindhu,

you can create a same size of buckets by using class function.

and

you posted..can i create age buckets for different dashboards....means....plz elaborate with more details.

Re: Script

Anonymous — Thu, 22 Dec 2016 04:55:47 GMT

For one dashboard, i have to create limits like 0-2 days,3-5days like tht,

For other dashboard,i have to create limits like 0-2 days,3-7 days like dt,

if i create means its shows the all limits in same dashboard,bt i need nly specific limits for specific dashboards.

Re: Script

Anonymous — Thu, 22 Dec 2016 04:57:10 GMT

i mean to say,can i use the same age bucket for different dashboards

Re: Script

Anonymous — Thu, 22 Dec 2016 04:59:50 GMT

Can you pls share the In-progress version of the script you have so that we can give our suggestions on that?

A sample should be a good way to

Re: Script

Anonymous — Thu, 22 Dec 2016 05:01:28 GMT

your using same data in both the dashboards?

Re: Script

Anonymous — Thu, 22 Dec 2016 05:03:57 GMT

Ofcourse kalyani, but i have to use same data only...for diff dshboard....how can i do ths.

Re: Script

Anonymous — Thu, 22 Dec 2016 05:08:24 GMT

Hi sindhu,

you can create a same size of buckets by using class function.

Ex:

LOAD Name, DOB, Age

Dual(Replace(Class(Age,5),'<= x <','to'), Num(Class(Aage,5))) as Bucket
FROM
[..\Desktop\Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

you can't create a same size of buckets by using if.

Ex:

LOAD Name, DOB Age,

If(Date(DOB)>='01/01/1945' and Date(DOB)<='12/31/1960', 'Baby Boomers',
If(Date(DOB)>='01/01/1961' and Date(DOB)<='12/31/1980', 'Gen X',
If(Date(DOB)>='01/01/1981' and Date(DOB)<='12/31/1995', 'Gen Y','Gen Z'))) as Gen

FROM
[..\Desktop\Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: Script

Anonymous — Thu, 22 Dec 2016 05:12:09 GMT

what is your exact requirement sindhu...

you shared something limits on dashboards....can you please more detail,

then i will get clarity on your ..scenario.

Re: Script

varshavig12 — Thu, 22 Dec 2016 05:14:01 GMT

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 ?

Re: Script

Anonymous — Thu, 22 Dec 2016 05:16:42 GMT

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.

Re: Script

Anonymous — Thu, 22 Dec 2016 05:20:11 GMT

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

Re: Script

PrashantSangle — Thu, 22 Dec 2016 05:28:32 GMT

Hi,

Create 2 bucket in script .

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

Regards,

Re: Script

Anonymous — Thu, 22 Dec 2016 05:33:24 GMT

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..

Re: Script

Anonymous — Thu, 22 Dec 2016 06:00:27 GMT

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

PrashantSangle — Thu, 22 Dec 2016 06:04:47 GMT

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

Re: Script

Anonymous — Thu, 22 Dec 2016 06:20:07 GMT

yeah dt fields are same