Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raghavsurya
Partner - Specialist
Partner - Specialist

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

1 Solution

Accepted Solutions
raghavsurya
Partner - Specialist
Partner - Specialist
Author

Hi Dennis,

I used the cross table functionality to resolve this issue. 

Regards,

Raghav

View solution in original post

19 Replies
Not applicable

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

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

ToniKautto
Employee
Employee

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

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

Not applicable

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

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

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

raghavsurya
Partner - Specialist
Partner - Specialist
Author

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