topic Re: How to make one field values independent to select any values and it should not greyed out the other values in other fields. in App Development

How to make one field values independent to select any values and it should not greyed out the other values in other fields.

sandeepk218 — Fri, 16 Jun 2023 10:20:15 GMT

Hi,

I need to make fields selection independent and not associated with other fields.

EXample - I have name, surname, city. on data model they are coming from same table so they are associated .

but on filter side, if I select one value from city, then all values from Name and surname should be available to select and vice versa.

Is there any way to achieve it apart from alternate state.

thank you.

Re: How to make one field values independent to select any values and it should not greyed out the other values in other fields.

Oleg_Troyansky — Fri, 16 Jun 2023 13:01:13 GMT

Hi Sandeep,

Alternate States would be the most natural solution to this. Other than that, you could configure your Filter Panes to show all values, disregarding any selections - something like this:

=AGGR(Only({1} City), City)

This formula will always show all Cities, no matter what was selected in other fields. You can make the formula more elaborate if you want to ignore only some of the field selections.

Check out my lecture on Set Analysis and AGGR at the Masters Summit for Qlik - you will learn this and many other advanced development techniques.

Re: How to make one field values independent to select any values and it should not greyed out the other values in other fields.

sandeepk218 — Fri, 16 Jun 2023 14:34:54 GMT

Hi Oleg,

Thank you for your reply. I tried your expression but it is not working. If I select any value in other fields then few Cities are greyed out which I don't want to happen.

Thanks,
Sandeep

Re: How to make one field values independent to select any values and it should not greyed out the other values in other fields.

simsa — Fri, 16 Jun 2023 17:48:30 GMT

Create a separate table in load editor:
Table_Filter:
LOAD Distinct Name
Resident Base_Table;