topic Need help in QlikView

Need help

Fri, 29 Nov 2013 05:36:02 GMT

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

Re: Need help

tresB — Fri, 29 Nov 2013 05:44:00 GMT

Could you post a sample app?

Re: Need help

Fri, 29 Nov 2013 06:02:55 GMT

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

Re: Need help

tresB — Fri, 29 Nov 2013 06:10:21 GMT

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

Re: Need help

sundarakumar — Fri, 29 Nov 2013 07:37:07 GMT

Hi Law,

Can you share a sample souce?

-Sundar

Re: Need help

Fri, 29 Nov 2013 09:05:29 GMT

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

];

Re: Re: Need help

sundarakumar — Fri, 29 Nov 2013 09:10:04 GMT

Hi Law,

Use advanced editor option to attach app

Re: Re: Re: Need help

Wed, 04 Dec 2013 02:06:02 GMT

Hi. Sorry for the very late response.

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

Re: Re: Need help

Thu, 05 Dec 2013 02:36:52 GMT

Anyone can help? Thanks

Re: Re: Re: Need help

Alejandro_Hernández — Thu, 05 Dec 2013 02:50:04 GMT

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

Re: Re: Re: Re: Need help

Thu, 05 Dec 2013 05:36:15 GMT

Hi. Thanks for the effort. But its not something that I want to achieve. Please take a look on the excel file. That's exactly I want to achieve. Hope you get what I mean.

Re: Need help

shreyashetty_ge — Thu, 05 Dec 2013 07:22:35 GMT

hi...well do you need to show the selected fields in the label of the expression ?

If so then try using this ..

getfieldselections (MonthAndYear2,'-')

Re: Re: Re: Re: Re: Need help

Alejandro_Hernández — Thu, 05 Dec 2013 07:27:46 GMT

as close as I can get to what you want without complicating it too much.

Re: Re: Re: Re: Re: Need help

Thu, 05 Dec 2013 07:58:26 GMT

Thanks. Im getting near, how should i modify that when I select on Calendar1, Calendar 2 should not select what I selected on calendar 1. Thanks