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

[Anonymous]

Go to "Use advanced editor" on the right upper corner of the editor box.

There you can upload stuff.

[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

[#4]

Hi Raghav,

  I am not able to see any data in the attached QVW . So i have created the sample data and used it. Attached the file for your reference. Let me know if you are looking for something else. Also please upload the sample data.

[ToniKautto]

The description of what you want to accomplish is still a bit too unclear to enable me to give any advice. The QVW you attached is also empty, I would have expected it to have at least a chart object that would alter its presentation based on selection in the list box. So please elaborate a bit further on what exactly you are trying to do.

Please add a lisbox and a other objects in the QVW, and load it with data, to give a more apprehensive scenario. Also please attach this QVW here for our convinience.

If the data contains senstitive info, please use the scrambling function to make it unreadable.

Settings > Document Settings > Scrambling

[raghavsurya]

Hi Toni,

There seems to be an issue because when I upload, it has the data and the chart as well put in.  But the same is not getting reflected when other person is viewing the same.

I happened to me as well... when I tried to open the qvw application attached by Logesh.... wherein the application was blank.

Regards,

Raghav

[Anonymous]

Toni Kautto wrote:

The description of what you want to accomplish is still a bit too unclear to enable me to give any advice. ..

I get the confusion. If I understand it correctly he want the fieldnames in a list.

Years is in his case not a field, but the header of a colum in Excel.

With the below Inline you could make the wanted list, but how do you connenct them to the fieldnames?

Years:

Load * Inline [

Year

2010

2011

2012

2013

2014

2015

];

[ToniKautto]

That sounds a bit weird. Please make sure you are not running any kind of reduction on the QVW, even though I can not see how this would remove chart objects. If you are not able to provide the QVW, could you at least provide a screen shot of what objects you are having on your sheet?

[Anonymous]

HI Raghav,

Did you already find a solution you can work with?

Maybe the attached file can help you.

Good luck.

[raghavsurya]

Thanks a lot Dennis.... this really helps.

Regards,

Raghav

[raghavsurya · Accepted solution]

Hi Dennis,

I used the cross table functionality to resolve this issue. 

Regards,

Raghav