How can i display my listbox data like this

[#1]

Hi All,

I have found the below listbox in API guide(Automationmembers Sheet) .I don't how the listbox is showing data like this.I see the script but i didn't understand.

But i need this requirement.

Can anyone suggest me how can i achieve this with some sample data?

Thanks....

[kaushiknsolanki]

Hi,

    Even with mapping load you will have same problem as you have in excel, cause you have duplicate values. So the work around is that in excel file for the similar value add one more space at any one set of duplicate value. so that according to qlikview they will not be the same.

Regards,

Kaushik Solanki

[#3]

Hi,

if you have repeated data there is a way too.

Is your data keep adding and new entries comes in or quite fixed?

if it is fixed you can add one more column similar to level, say column repeat. So you need to flag the data and if it repeats you need to add trailing spaces accordingly.

Eg.

Field

   Bad

Field1

   Bad Chr(32)

Filed2

  Baf Chr(32) & Chr(32)

So if you load this way data is different and display well in the list box, user cnt see the trailing spaces.

I worked out this way some time back.

Cheers.

[#4]

BlackRocks,

My data contains several types of repeated items.

Thanks..

[#5]

Hi,

If your data repeats i never mind, use the attached logic.

Cheers.

[#6]

BlackRocks,

Please go through with the attached Qvw file.

I am facing two problems.

1->when i am reloading the file i am getting one error like GiveMeSpaceString is not a valid function.

2->If i am placing the same code In your sent file.It doesn't show any error message.But i am not getting the data as you get.

Let me know what happened and any mistake from my side?

Thanks.

[#7]

Hi,

You havent copied the macro script from edit module, the function GiveMeSpaceString is written in macros script part.

Please find the attached sample which is working fine.

Cheers.

[#8]

Blackrock,

Thanks a lot.

But still i didn't get the output as you get( This is the file what you sent "DisplayListBoxEnhanced.qvw").This point also i have mentioned in my previous post.

Can i get the output like that?

Thanks...

[#9]

hyg