topic Re: Filter panel using one field values and filter by another field in App Development

Filter panel using one field values and filter by another field

igorgois_ — Sat, 16 Nov 2024 18:33:42 GMT

Hello,

I have this following table

FACT:

LOAD * inline [

Company,Category,Flag_is_client

1,A,1

2,A,0

3,B,1

4,B,1

5,B,1

6,C,0

];

I would like a filter panel that shows the Companys name that have flag_isclient = 1 and when the user select the company name, Qlik sanse actually filter the category linked to that company

I tried with aggr(company,category) but didnt work.

Can anyone help me?

Thanks in advance

Re: Filter panel using one field values and filter by another field

jwjackso — Mon, 01 Jun 2020 18:45:47 GMT

Try using an alternate state (ex: IsClient) on the filter pane with an expression like =If(Flag_is_client = 1,Company,Null()) to get a list of the companies. Then in the chart where you want to filter by category, try using P() function in Set Analysis =Count({<Category=P({IsClient}Category)>}Category)

Re: Filter panel using one field values and filter by another field

igorgois_ — Mon, 01 Jun 2020 18:52:07 GMT

Thanks for your answer.

But I need to filter all the app. Not only in one specific graph

Thank you

Re: Filter panel using one field values and filter by another field

jwjackso — Mon, 01 Jun 2020 19:05:36 GMT

Within the load script

FACT:

LOAD * inline [

Company,Category,Flag_is_client

1,A,1

2,A,0

3,B,1

4,B,1

5,B,1

6,C,0

];

CategoryFilter:

load Company as CompanyAlias, //so it doen't filter the company

Re: Filter panel using one field values and filter by another field

jwjackso — Mon, 01 Jun 2020 19:07:42 GMT

Forgot to add a where clause to limit the companies, within the load script

FACT:

LOAD * inline [

Company,Category,Flag_is_client

1,A,1

2,A,0

3,B,1

4,B,1

5,B,1

6,C,0

];

CategoryFilter:

load Company as CompanyAlias, //so it doen't filter the company

Re: Filter panel using one field values and filter by another field

igorgois_ — Mon, 01 Jun 2020 19:25:46 GMT

Thanks again for your answer.

I forgot to mention that I cant change the script.

I had already done your solution using script, but I am looking for a solution in the front end 😕

Thanks again