topic Re: column active on different Listbox(month) in QlikView

column active on different Listbox(month)

Fri, 20 Dec 2013 15:17:11 GMT

Dear All,

In my application there are one month field, but due to some requirement in pivot table I want to give three month list box , So on the selection of 1st listbox one Actual column will active and on the selection of 2nd listbox Budget column will react.

Jan

Feb

Mar

April

May

Jun

Jan

Feb

Mar

April

May

Jun

Name	Actual	Budget
A	2000	5000
B	5000	2000

Regards,

Rahul

Re: column active on different Listbox(month)

swuehl — Fri, 20 Dec 2013 15:40:55 GMT

There are probably several solutions to this, also depending on your overall requirements and data model.

For example, you can create independent master calendars for actual and budget months, please have a look at

Tutorial - Using Common Date Dimensions and Shared Calendars

Or use alternate states for the different month list boxes and set analysis for the calculations.

Re: column active on different Listbox(month)

Gysbert_Wassenaar — Fri, 20 Dec 2013 15:50:10 GMT

If you're using QV11 you can use alternate states to solve this. Create an alternate state for each listbox on the General tab of the Document properties window. Next assign the alternate states to the listboxes on the General tab of the properties window of the listboxes. Suppose you named your alternate states AS1 and AS2. In your pivot table you can now add two expressions for Actual and Budget. For example:

Actual: sum({AS1} Actual_Value)

Budget: sum({AS2} Budget_Value)

A selection in the month listbox with alternate state AS1 will only affect the Actual expression. A selection in the other listbox will only be applied to the Budget expression.

Note: replace Actual_Value and Budget_Value with your real field names.

Re: column active on different Listbox(month)

Sat, 21 Dec 2013 07:19:39 GMT

But I am using QV10 , so if I have to do this I have to Up gradate QV10 to QV11...?

And if I go for upgradation of QV10 to QV11 on same server , Is I have to creates all task and changes again on server.. ??

Re: Re: column active on different Listbox(month)

Gysbert_Wassenaar — Sat, 21 Dec 2013 12:00:34 GMT

If you're using QV10 you can do something similar with input boxes and variables. But you'll get dropdown boxes instead of listboxes. See attached example.

Re: Re: column active on different Listbox(month)

swuehl — Sat, 21 Dec 2013 12:28:34 GMT

Yes, you need QV11 and up to use alternate states.

If you want to upgrade, please prepare thoroughly, get some help and / or search the docs / forum, e.g. for

http://community.qlik.com/thread/91356

Instead of alternate states, you can also try data islands for the two month selections. Please check attached.

Re: column active on different Listbox(month)

Mon, 30 Dec 2013 10:59:39 GMT

Sry but can you give a simple .qvw bz the qvw given by you is not easy to understand...I created a master calender but not able to find the right way...Plz provide some easy example ...

Re: Re: column active on different Listbox(month)

Gysbert_Wassenaar — Mon, 30 Dec 2013 11:14:29 GMT

The script of the example doesn't matter, but here's a cleaned up version.

Re: Re: Re: column active on different Listbox(month)

Mon, 30 Dec 2013 12:35:58 GMT

thanks for instant reply... plz tell me how to arrange these months in Jan Feb March......PLz find attachment..

Re: Re: Re: column active on different Listbox(month)

Mon, 30 Dec 2013 13:45:51 GMT

Thanks done...