Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
raghavsurya
Partner
Partner

combining more than 1 dimension into single listbox

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

19 Replies
dennisnet
Partner
Partner

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

There you can upload stuff.

raghavsurya
Partner
Partner
Author

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

Not applicable

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
Employee
Employee

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
Partner
Partner
Author

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

dennisnet
Partner
Partner

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
Employee
Employee

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?

dennisnet
Partner
Partner

HI Raghav,

Did you already find a solution you can work with?

Maybe the attached file can help you.

Good luck.

raghavsurya
Partner
Partner
Author

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

Regards,

Raghav

raghavsurya
Partner
Partner
Author

Hi Dennis,

I used the cross table functionality to resolve this issue. 

Regards,

Raghav

View solution in original post