Need help

[#1]

Hi. I have two listbox that consist of two calendars month. What Im trying to achieve is something like this.

Name              Jan - Feb               Mar - May

                      x          y               x          y

Ryan               2         3               3           2

Joey                3         2               2           3

Listbox1: Selected Jan-Feb

Listbox2: Selected Feb-May

Please help me. Thanks

[tresesco]

Could you post a sample app?

[#3]

I dont have the sample app but the chart is something I want to achieve. Could you help me please?

[tresesco]

To understand your requirement, sample app would be required. Please refer: Preparing examples for Upload - Reduction and Data Scrambling

[sundarakumar]

Hi Law,

Can you share a sample souce?

-Sundar

[#6]

Here is the sample code. How can I attah the sample app here? Sorry, Im new to this community

Calendar1:

LOAD * INLINE [

    ID,Date,MonthAndYear

    1,'1/1/2013','Jan 2013'

    2,'2/1/2013','Feb 2013'

    3,'3/1/2013','Mar 2013'

    4,'4/1/2013','Apr 2013'

    5,'5/1/2013','May 2013'

];

Calendar2:

LOAD * INLINE [

    MonthID2,Date2,MonthAndYear2

    1,'1/1/2013','Jan 2013'

    2,'2/1/2013','Feb 2013'

    3,'3/1/2013','Mar 2013'

    4,'4/1/2013','Apr 2013'

    5,'5/1/2013','May 2013'

    6,'6/1/2013','Jun 2013'

    7,'7/1/2013','Jul 2013'

    8,'8/1/2013','Aug 2013'

];

Transaction:

LOAD * INLINE [

    EmpID,NSD,OT,Date

    1,3,4,'1/1/2013'

    1,3,4,'2/1/2013'

  1,3,4,'3/1/2013'

  1,3,4,'4/1/2013'

  1,3,4,'5/1/2013'

  1,3,4,'6/1/2013'

  1,3,4,'7/1/2013'

  1,3,4,'8/1/2013'

  2,3,4,'1/1/2013'

  2,3,4,'2/1/2013'

  2,3,4,'3/1/2013'

  2,3,4,'4/1/2013'

  2,3,4,'5/1/2013'

  2,3,4,'6/1/2013'

  2,3,4,'7/1/2013'

];

Employee:

LOAD * INLINE [

    EmpID,Name

    1,Ryan

    2,Joey

    ];

[sundarakumar]

Hi Law,

Use advanced editor option to attach app

[#8]

Hi. Sorry for the very late response.

Attached herewith is the sample file I've been working on. Thanks

[#9]

Anyone can help? Thanks

[Alejandro_Hernández]

I'd use alternate states for that. I've attached an example.