Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Go to "Use advanced editor" on the right upper corner of the editor box.
There you can upload stuff.
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
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.
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
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
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
];
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?
HI Raghav,
Did you already find a solution you can work with?
Maybe the attached file can help you.
Good luck.
Thanks a lot Dennis.... this really helps.
Regards,
Raghav
Hi Dennis,
I used the cross table functionality to resolve this issue.
Regards,
Raghav