Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Selection on the basis of Inline Filter

We are facing issue in using Inline filter which is not linked with the data model.

We have two table with same column but different region and we are creating inline Filter like Region1, Region2 and All.

we want to use this inline filter like if we select Region1 then we need to show data related to Region1 only and same for region2 and if we select on All then data of both region should show, but currently what is happening is that if we select Region1 then data in the filter is coming correct but when we select customer of region1 then selection goes to All and Region1 Filter instead of only Region1.

Please find the attached file for reference.

Thanks in Advance !

3 Replies

Try your script like this

Table:

LOAD * INLINE [

    Country , Region2Col, Region1Col, MainCol

    Region1, , Reg1Val1,

    Region1, , Reg1Val2,

    Region1, , Reg1Val3,

    Region1, , Reg1Val4,

    Region1, , Reg1Val5,

];


LOAD * INLINE [

    Country , Region2Col, Region1Col, MainCol

    Region2, Reg2Val1, ,

    Region2, Reg2Val2, ,

    Region2, Reg2Val3, ,

    Region2, Reg2Val4, ,

    Region2, Reg2Val5, ,

];


LOAD * INLINE [

    Country , Region2Col, Region1Col, MainCol

    Region2, , , Reg2Val1

    Region2, , , Reg2Val2

    Region2, , , Reg2Val3

    Region2, , , Reg2Val4

    Region2, , , Reg2Val5

    Region1, , , Reg1Val1

    Region1, , , Reg1Val2

    Region1, , , Reg1Val3

    Region1, , , Reg1Val4

    Region1, , , Reg1Val5

];


LinkTable:

LOAD DISTINCT Country,

Country as CountryName

Resident Table;


Concatenate (LinkTable)

LOAD DISTINCT Country,

'All' as CountryName

Resident Table;

Partner
Partner

Much appreciate Sunny for your response, but this also not serve our requirement like if we select Region1 in the RegionName filter then data in the filter Customer is coming correct but when we select any customer of region1 then selection of RegionName goes to All and Region1 And same data presented in the table instead we need to show only selected data in the table.

You have used a calculation to calculate customer on the front end... why don't you do this in the script? To combine all the customers into a single customer column?