Create dynamic table based on value selected in a listbox

[#1]

Hello,

I have the the following table loaded (refer code below).

Data:
LOAD * INLINE [
BookedCountry, ManagedCountry, Revenue
France, France, 100
France, Canada, 150
France, Brazil, 80
Germany, Canada, 180
Germany, India, 220
];

I have a listbox for [BookedCountry]. I want to use a script to create a table which will use the table Data as resident table with the where value will be the value I select in the listbox [BookedCountry].

Can you please help me out.

Regards,

Ayandeep

[arvind_patil]

Hi Ayandeep,

After data load, you can perform the selection operation. You can't generate script throw Selection. In another alternative, you can use resident load to perform any operation.

Thanks,

Arvind Patil

[avinashelite]

Your requirement is to show the data which is related to your selection ? if that is the case you could add a table box or      straight table and its will filter the records based on your selection 

[qv_testing]

here you go !!

PFA

[Siva_Sankar]

dynamically creating objects based on selection in listbox

[arvind_patil]

Please look into adhoc Reporting:

Adhoc reporting in Qlikview

Thanks,

Arvind Patil

[#7]

Hi Raju,

Can you please provide your solution in the form of screenshots? I have Qlikview personal edition so not able to open your attachment.

Regards,

Ayandeep

[#8]

Hi Avinash,

The requirement is to data related to my selection but on a SVGMap so I need the data on a table in the script. Can you please help me out?

Regards,

Ayandeep

[qv_testing]

create  two list boxes.

one for dimension's

one for Expressions

Like this

Dimensions:

Load * Inline [

Dimensions%

BookedCountry

ManagedCountry

//Note:  If you have any dimension's add in Dimensions table

];

Measure:

Load * Inline [

Measure%

Revenue

];

//Note:  If you have any Measure's add in Measure table

Take a straight table,

Dimension: BookedCountry and ManagedCountry

Measure: Sum(Revenue)

Dimension1: Conditional Expression

=GetSelectedCount(Dimensions%)>=1 AND concat(Dimensions%,',') like '*BookedCountry*'

Dimension2: Conditional Expression

=GetSelectedCount(Dimensions%)>=1 AND concat(Dimensions%,',') like '*ManagedCountry*'

Expression: COnditional Expression

=IsNum( SubStringCount( GetFieldSelections(Measure%), 'Revenue')) and SubStringCount( GetFieldSelections(Measure%), 'Revenue') > 0

Final output,

Make any selection, chart will populate....

Hope it helps...

[avinashelite]

That is not possible ...only way i could think is the Direct discovery that is the one option to build the data table dynamically in the script