combining more than 1 dimension into single listbox

[raghavsurya]

Hi All,

Is there a way we can combine more than one dimension into one list box.  I have a situation wherein I have budgets for next 10 years as columns.  Can I have all these 10 years combined into one list box for selection.

Particulars          2011          2012         2013     2014         2015     and so on

Sales

Direct Cost

Indirect Cost

Please let me know if you have encountered similar requirement.

Regards,

Raghav

[#2]

Hi ,

Are you want to dispaly like this

2011-2012-2013

Then use the expression  option in the list box as

Column & 'Seperator ' & column1 & 'Seperator2 '& Column2 ....

[johnpaul]

I think that expressions only work within listboxes from version 10 onwards.

[ToniKautto]

I am not completely following on in what way you want to present the listbox.

Creating a static concatenated string as suggested above might be better to do in the load script, so that you can deside what the selection should lead to.

Please clarify what the list box should look like, and what you expect to happen when you slect a row in it.

[raghavsurya]

I want a list box to display the years like  FY 2010-11, FY 2011-12, FY2012-13.  Also want the charts to represent the data for the specific year which I select.

Regards,

Raghav

[#6]

Hi Raghav,

One more option u can create a column in the edit script by combining the dimensions and it will be faster than than creating an expression in the list box.

[raghavsurya]

Hi Logesh,

All the data is available in Excel sheets and for each year the data runs into 13,000 lines.  Can you please help with a sample script to combine the deimensions.

Regards,

Raghav

[ToniKautto]

Please upload a sample QVW to make it easier to suggest a solution to your problem, as a specific solution is a bit dependant on your data model.

[raghavsurya]

Hi Toni,

I have attached a sample file for your reference which has product data sales projections for future years.  I need years to shown in a list box.  The product data in real sense runs into 13,000 rows.  Please suggest how to make year as a dimension directly in the script.

Regards,

Raghav

[raghavsurya]

Sorry.... I am not finding a link to upload the qv application.