topic Re: How can i display my listbox data like this in QlikView

How can i display my listbox data like this

Tue, 23 Aug 2011 12:55:26 GMT

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

Re: How can i display my listbox data like this

its_anandrjs — Tue, 23 Aug 2011 13:01:19 GMT

Hi,

The object that you ask for it is a hierarchical view for this you need to create a data like hierarchy view by the use of Hierarchy(Fields,.,.,.,.,.) by this you achieve this type of view.

Regards,

Anand

Re: How can i display my listbox data like this

Tue, 23 Aug 2011 13:14:17 GMT

Hi Anand,

Thanks for your reply

Please reply with one simple example.

Thanks...

Re: How can i display my listbox data like this

Or — Tue, 23 Aug 2011 13:20:49 GMT

I found this explanation useful. See if it helps.

Re: How can i display my listbox data like this

its_anandrjs — Tue, 23 Aug 2011 13:25:29 GMT

Hi,

See the attached sample for clearity, it is explaining small data how to show the hiererchical view of the data.

Regards,

Anand

Re: How can i display my listbox data like this

Tue, 23 Aug 2011 13:33:01 GMT

Hi Shoham,

I don't need like this (this is treeview structure).

The problem with this is If i want to select any child ,i need to expand it's parent.

I need only like the image what i have attached in my earlier post.

Sample data:

World

Europe

France

Italy

Africa

Nigeria

South Africa

Asia

Singapore

Japan

China

North America

USA

Canada

South America

Australia

New Zeeland

Oceania

Colombia

Brazil

Thanks....

Re: How can i display my listbox data like this

Tue, 23 Aug 2011 13:45:26 GMT

Hi Anand,

But the image what i have attached is showing the data not like this.

Any Idea about the data representation like that as in API guide?

Thanks...

How can i display my listbox data like this

Or — Tue, 23 Aug 2011 14:01:19 GMT

Unfortunately, the example you provide from the API guide is not in any way a hierarchy - it is simply a list of items, some of which have leading whitespaces. These items are sorted in load order and thus look like a hierarchy would, but they are not in any way related (to confirm this, you can open the listbox, change the sort order, and see what happens). You could copy that technique as long as you maintain the correct order, I suppose...

Re: How can i display my listbox data like this

SunilChauhan — Tue, 23 Aug 2011 15:38:27 GMT

hello

when u see code of api guide you will find

mapindents:

mapping load * inline [

x1,x2

Button,Button

CurrentSelection, CurrentSelectionBox

GraphBasics, GraphBasics

Graph, Graph

PivotTableBox, PivotTableBox

StraightTableBox, StraightTableBox

InputBox, InputBox

LineArrow, LineArrowObject

ListBox, ListBox

MultiBox, MultiBox

StatisticsBox, StatisticsBox

TableBox, TableBox

TextObject, TextObject

CustomObject, CustomObject

BookmarkObject, BookMarkObject

Slider, Slider

];

you will see all items have some space after comma.

if remove this comma you will see all items willl look like a list box.

see the attached file.

How can i display my listbox data like this

its_anandrjs — Tue, 23 Aug 2011 18:30:09 GMT

Hi,

Yes it is different that i explain to you it is a hierarchy view.

Regards,

Anand

How can i display my listbox data like this

its_anandrjs — Tue, 23 Aug 2011 18:38:49 GMT

Hi,

The image that you ask for iot is a mapping load, it is created by mapping load of the two tables.

Regards,

Anand

Re: How can i display my listbox data like this

its_anandrjs — Tue, 23 Aug 2011 18:42:58 GMT

Hi,

See the attached ssample it is clear for you there. It is just mapping load to connect the data of the tables.

Regards,
Anand

Re: How can i display my listbox data like this

Wed, 24 Aug 2011 06:04:45 GMT

Anand,

Can you explain me how the mapping is happened with the below example.

eg:

World

Europe

France

Italy

Africa

Nigeria

South Africa

Asia

Singapore

Japan

China

North America

USA

Canada

South America

Australia

New Zeeland

Oceania

Colombia

Brazil

Thanks....

Re: How can i display my listbox data like this

its_anandrjs — Wed, 24 Aug 2011 07:21:17 GMT

Hi,

For this you need to set mapping codes in the load script, I suggest you please refer the ApiGuide.

Regards,

Anand

Re: How can i display my listbox data like this

kaushiknsolanki — Wed, 24 Aug 2011 07:26:22 GMT

Hi,

In API guide, they have used mappings but if you want to keep it simple then you can type this values in excel as you want including the spaces. Then load that data in qlikview. It will show you as you have defind in excel.

Regards,

Kaushik Solanki

Re: How can i display my listbox data like this

its_anandrjs — Wed, 24 Aug 2011 07:40:45 GMT

Hi,

See the attachment file for clearity as if you want to keep it only simple then just load with excel file and now check the sample file. But if you need to create a mapping so then you need to create a mapping load.

Regards,

Anand

Re: How can i display my listbox data like this

Wed, 24 Aug 2011 08:27:56 GMT

Anand,

I want the data based on the mappingload.If i use excel,I have a problem like the data repetetion.

Thanks..

Re: How can i display my listbox data like this

Wed, 24 Aug 2011 08:35:28 GMT

Kaushik,

Tell me about how can i do that with mappingload.

Thanks.....

Re: How can i display my listbox data like this

Wed, 24 Aug 2011 08:47:14 GMT

Hi,

Please see if the attached can help you.

Cheers.

Re: How can i display my listbox data like this

Wed, 24 Aug 2011 09:18:14 GMT

Hi BlackRocks,

Thanks for your reply

With this also i am not able to get the repeated data.

How can i get like this?

Field

Bad

BadFields

Messagefor BadFields

Good

Field1

Bad

BadFields

Messagefor BadFields

Good

Thanks..