Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There are two filters on my Qlik sense app.
Filter-1 uses column1/field1
Filter-2 uses column2/field2
How to apply 'Qlik sense Set Analysis' or other method to make Filter-1 will NOT impact/filter Filter-2?
Thanks!
For what kind of purpose do you want this filter 1 to serve?
It is always possible to create a data island. A table that is totally disconnect from any other tables in the associative model. Then you can use values in this table to just make selections without impacting selections in the rest of the data model. You can via the expressions in Qlik Sense use the selections in this data island however.
So in your case you will have to make a copy of the field1 values into a new table with just on field that is named differently. You can do that in your load script:
DATA_ISLAND_1:
LOAD DISTINCT
field1 AS field1_
RESIDENT
Table;
Hey Petter , thanks for your help!
Filter-1 will NOT impact/filter Filter-2, but Filter-1should impact/filter all other Qlik object on the app.
Filter-2 should impact/filter all the Qlik object on the app.
Really appreciate if you could give any further suggestion?
I am also trying to use a Alternate States for Qlik Sense.
Hello!
Could you explain how field1 and field2 are related? Is there a hierarchical relationship like group/subgroup between them?
We may be able to help you better knowing this.
Regards.
Hi Angel,
Field1 and Field2 are just regular separate fields from a table. They do not have hierarchical relationship.
Any suggestion?
Thanks!
Hi,
If you are trying to apply the set analysis in any measures, can you share the calculation condition or measure definition to us?
Thanks.
Hi Silambarasan, I tried to use Set Analysis, but have not figured out a solution now.
As I only use a regular Qlik sense filter object with one regular field/column as input, there is no aggregation function.
Hi Haikuo,
Can you share the expression you are trying to achieve?
Thanks.
Hello,
If you want to use it in set analysis, try the below code
FilterField1={"=column1/field1"}
FilterField2={"=column2/field2"}
Otherwise share the expression you needed.
Thanks.
try this
Any selection made on Filter1 will not be impacted through out the application.
sum({1<Filter1=,>}sales)