topic Selection on the basis of Inline Filter in QlikView

Selection on the basis of Inline Filter

badri-adeel — Mon, 08 Oct 2018 13:36:56 GMT

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 !

Re: Selection on the basis of Inline Filter

sunny_talwar — Mon, 08 Oct 2018 19:38:25 GMT

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;

Re: Selection on the basis of Inline Filter

badri-adeel — Tue, 09 Oct 2018 04:32:37 GMT

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.

Re: Selection on the basis of Inline Filter

sunny_talwar — Tue, 09 Oct 2018 15:17:06 GMT

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?