topic Connection between multibox and table box in QlikView

Connection between multibox and table box

Thu, 22 Sep 2011 09:20:42 GMT

Hi,

I created multibox on days field i.e.,Sunday,Monday.....

I created table box which has data as

Job SchedulingDays

A Mon

B mon,tue

C Wed,Thu,Fri

D mon,Wed,Thu,Fri,Sat

E Sun,Mon,tue

Now I have requirement like

If we click on Mon in multibox,It has to show jobs and sheduling days which are running on both mondays and multiple days i.e., as below

Job Schedulingdays

A Mon

B mon,tue

D mon,tue,wed,thu,fri,sat

E Sun.mon

If we click on tue in multibox,It has to show jobs and sheduling days which are running on both tuedays and multiple days i.e., as below

Job Schedulingdays

B mon,tue

E Sun,mon,Tue

Please let me know how to do this

Connection between multibox and table box

its_anandrjs — Thu, 22 Sep 2011 09:34:08 GMT

Hi,

Use Concat function to achieve this

Concat(ColB, '')

Rgds

Anand

Re: Connection between multibox and table box

its_anandrjs — Thu, 22 Sep 2011 09:45:00 GMT

Hi,

You need to load data some thing like below

Temp:

Load * inline [

Job, SchedulingDays

A, Mon

B, Mon

B, Tue

C, Wed

C, Thu

C, Fri

D, Mon

D, Wed

D, Thu

D, Fri

D, Sat

E, Sun

E, Mon

E, Tue

];

Data:

Load

Job,

Concat(SchedulingDays, ' ') as NewField

Resident Temp

group by Job;

Let me know

Rgds

Anand

Re: Connection between multibox and table box

its_anandrjs — Thu, 22 Sep 2011 09:55:32 GMT

Hi,

See the attached sample file.

HTH

Rgds

Anand

Connection between multibox and table box

jonathandienst — Thu, 22 Sep 2011 09:58:43 GMT

You will need to use a straight table rather than a table box. Use Job as the dimension and use the expression:

=If(Index(lower(SchedulingDays), lower(DaysField)) > 0, SchedulingDays)

This will work as long as only one DaysField is selected.

Hope that helps

Jonathan

Connection between multibox and table box

Thu, 22 Sep 2011 11:01:01 GMT

Hi actually in my Excel sheet we have data as below

Job,ScheduleDays

A 2

B 2,3

C 4,5,6

D 2,4,5,6,0

E 1,2,3

that means 0-Sat;1-sun;2-mon........

I converte into days using mapping table

let me know how to do the task mentioned in previous post with data

On which fields we have to take multibox and table box

please let me know as soon aspossible

Connection between multibox and table box

Thu, 22 Sep 2011 11:30:07 GMT

Hi,

Please let me know step by step to get the output as mentioned above

Connection between multibox and table box

Jason_Michaelides — Thu, 22 Sep 2011 11:33:04 GMT

If you are already using mapping in your script to convert the days you are almost there. Complete it using an abstracted table with SubField():

Map_Days:

MAPPING LOAD * INLINE [

DayNum,Day

0,Sat

1,Sun

2,Mon

3,Tue

4,Wed

5,Thu

6,Fri

];

Data:

LOAD

Job,

ScheduleDays

FROM ExcelFile...;

Days:

LOAD

Job,

ApplyMap('Map_Days',SubField(ScheduleDays,','),'<Unknown>') AS Day

RESIDENT Data;

This will create a record in the new table "Days" for every day in each job schedule and enable you to select one or multiple days and get all Jobs with those days contained.

Hope this helps,

Jason