Discussion Board for collaboration related to QlikView App Development.
I have the the following table loaded (refer code below).
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.
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.
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
here you go !!
Please look into adhoc Reporting:
Can you please provide your solution in the form of screenshots? I have Qlikview personal edition so not able to open your attachment.
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?
create two list boxes.
one for dimension's
one for Expressions
Load * Inline [
//Note: If you have any dimension's add in Dimensions table
Load * Inline [
//Note: If you have any Measure's add in Measure table
Take a straight table,
Dimension: BookedCountry and ManagedCountry
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
Make any selection, chart will populate....
Hope it helps...
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