topic Re: Data Selection in App Development

Data Selection

louise119 — Fri, 15 Nov 2024 21:49:15 GMT

I want to change the value output to the filter depending on the conditions.

Currently, the if statement is used to determine the contents of the filter as shown below, but the data is not inherited when linked to another sheet. Because the formula is different (Sheet A and Sheet B).
What should I do?

When I selected the data Region="US" on sheet A, the selected data Region="US" is selected on sheet B as well.
That's what I want to do.

【SheetA】
filter:
If(Region="US" or Region="UK",Region)

【SheetB】

filter:
If(RegionX="US" or RegionX="UK" or RegionX="China" or RegionX="Korea" or RegionX="France",RegionX)

Re: Data Selection

Chanty4u — Thu, 11 May 2023 05:41:34 GMT

To achieve the desired behavior where the filter selection on Sheet A affects the filter on Sheet B, you can use the Qlik Sense native feature called "Alternate States." Alternate States allow you to create separate, independent sets of selections within a Qlik Sense app.

Re: Data Selection

louise119 — Thu, 11 May 2023 06:20:51 GMT

Thank you so much.
I'm sorry my explanation was not enough.

For example, if Japan is selected in the test sheet, I want Japan to be selected in the test2 sheet as well.

Currently, Japan is not highlighted in green on the test2 sheet.
Because the filter formula is different between test and test2. (refer to the following)

test:=If(Region='USA' or Region='Japan',Region)
test2: =If(Region='USA' or Region = 'Japan' or Region = 'UK' ,Region)

Re: Data Selection

Chanty4u — Thu, 11 May 2023 06:39:46 GMT

May be modify this

test:=If(Region='USA' or Region='Japan',Region)

test2: =If(test,Region)

Re: Data Selection

louise119 — Thu, 11 May 2023 07:09:02 GMT

Thank you for reply.
I can't change the test2 formula because I wanna filter with Region = USA or Region = Japan or Region = UK only...

Re: Data Selection

N30fyte — Thu, 11 May 2023 13:32:27 GMT

Hi @louise119 !

I think this does what you want.

I started with the following two simple loads:

aregiontable:

LOAD * inline [
aregion
UK
USA
Europe
China
];

bregiontable:

LOAD * inline [
bregion
UK
USA
Europe
China
];

I created a sheet called Region A, with a filter pane to select from dimension aregion.

Next I created a sheet called Region B. In Actions for this sheet, I chose:

Action: Select values in a field

Field: bregion

Value: =GetFieldSelections(aregion,';')

I also added a filter pane to show the selections in bregion.

When I make selections from the a region/dimension on the filter pane in Sheet Region A:

then switch to Sheet Region B, the same selections are made in the b region/dimension:

I believe that if you have more than 6 regions you will need to modify the Value under Actions to increase the maximum:

=GetFieldSelections(aregion,';',25)

But I haven't tested this.