topic Re: Create dynamic table based on value selected in a listbox in QlikView

Create dynamic table based on value selected in a listbox

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Create dynamic table based on value selected in a listbox

arvind_patil — Mon, 24 Jul 2017 09:25:11 GMT

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

Re: Create dynamic table based on value selected in a listbox

avinashelite — Mon, 24 Jul 2017 09:25:35 GMT

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

Re: Create dynamic table based on value selected in a listbox

Nagaraju_KCS — Mon, 24 Jul 2017 09:26:51 GMT

here you go !!

PFA

Re: Create dynamic table based on value selected in a listbox

Siva_Sankar — Mon, 24 Jul 2017 09:28:00 GMT

dynamically creating objects based on selection in listbox

Re: Create dynamic table based on value selected in a listbox

arvind_patil — Mon, 24 Jul 2017 09:29:59 GMT

Please look into adhoc Reporting:

Adhoc reporting in Qlikview

Thanks,

Arvind Patil

Re: Create dynamic table based on value selected in a listbox

Mon, 24 Jul 2017 09:31:44 GMT

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

Re: Create dynamic table based on value selected in a listbox

Mon, 24 Jul 2017 09:45:36 GMT

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

Re: Create dynamic table based on value selected in a listbox

Nagaraju_KCS — Mon, 24 Jul 2017 09:54:40 GMT

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

Re: Create dynamic table based on value selected in a listbox

avinashelite — Mon, 24 Jul 2017 10:01:14 GMT

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

Re: Create dynamic table based on value selected in a listbox

Nagaraju_KCS — Mon, 24 Jul 2017 10:11:31 GMT

Halder, misunderstood, I thought Dynamic report.

Anyway i.e only possibility Direct Discovery.