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

[its_anandrjs]

Hi,

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

Regards,

Anand

[its_anandrjs]

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

[#4]

Anand,

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

eg:

World

   Europe

     UK

     France

      Italy

   Africa

     Nigeria

     South Africa 

   Asia

     Singapore

     Japan

     China

   North America

     USA

     Canada

   South America

     Australia

     New Zeeland

   Oceania

     Colombia

     Brazil

Thanks....

[its_anandrjs]

Hi,

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

Regards,

Anand

[kaushiknsolanki]

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

[its_anandrjs]

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

[#8]

Anand,

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

Thanks..

[#9]

Kaushik,

Tell me about how can i do that with mappingload.

Thanks.....

[#10]

Hi,

Please see if the attached can help you.

Cheers.

[#11]

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