topic combining more than 1 dimension into single listbox in QlikView

combining more than 1 dimension into single listbox

raghavsurya — Mon, 09 May 2011 06:37:44 GMT

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

combining more than 1 dimension into single listbox

Mon, 09 May 2011 06:44:47 GMT

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

combining more than 1 dimension into single listbox

johnpaul — Mon, 09 May 2011 09:06:50 GMT

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

Re: combining more than 1 dimension into single listbox

ToniKautto — Mon, 09 May 2011 09:17:51 GMT

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.

Re: combining more than 1 dimension into single listbox

raghavsurya — Mon, 09 May 2011 09:26:45 GMT

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

combining more than 1 dimension into single listbox

Mon, 09 May 2011 09:39:09 GMT

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.

combining more than 1 dimension into single listbox

raghavsurya — Mon, 09 May 2011 09:54:15 GMT

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

Re: combining more than 1 dimension into single listbox

ToniKautto — Mon, 09 May 2011 10:44:16 GMT

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.

combining more than 1 dimension into single listbox

raghavsurya — Mon, 09 May 2011 12:13:08 GMT

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

combining more than 1 dimension into single listbox

raghavsurya — Mon, 09 May 2011 12:19:41 GMT

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

combining more than 1 dimension into single listbox

Anonymous — Mon, 09 May 2011 12:34:03 GMT

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

There you can upload stuff.

Re: combining more than 1 dimension into single listbox

raghavsurya — Mon, 09 May 2011 12:45:50 GMT

Hi Toni,

Regards,

Raghav

Re: combining more than 1 dimension into single listbox

Mon, 09 May 2011 13:11:26 GMT

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.

Re: combining more than 1 dimension into single listbox

ToniKautto — Mon, 09 May 2011 13:51:00 GMT

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

Re: combining more than 1 dimension into single listbox

raghavsurya — Mon, 09 May 2011 13:55:33 GMT

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

Re: combining more than 1 dimension into single listbox

Anonymous — Mon, 09 May 2011 13:57:57 GMT

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

];

Re: combining more than 1 dimension into single listbox

ToniKautto — Mon, 09 May 2011 14:07:34 GMT

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?

Re: combining more than 1 dimension into single listbox

Anonymous — Tue, 24 May 2011 13:44:51 GMT

HI Raghav,

Did you already find a solution you can work with?

Maybe the attached file can help you.

Good luck.

Re: combining more than 1 dimension into single listbox

raghavsurya — Wed, 25 May 2011 04:57:47 GMT

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

Regards,

Raghav

combining more than 1 dimension into single listbox

raghavsurya — Wed, 25 May 2011 05:02:49 GMT

Hi Dennis,

I used the cross table functionality to resolve this issue.

Regards,

Raghav