Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datalakeyu
Specialist
Specialist

Qlik sense Set Analysis question

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!

15 Replies
petter
MVP
MVP

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;

datalakeyu
Specialist
Specialist

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.


amonjaras
Partner
Partner

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.

datalakeyu
Specialist
Specialist

Hi Angel,

Field1 and Field2 are just regular separate fields from a table. They do not have hierarchical relationship.

Any suggestion?

Thanks!

arasantorule
Creator III
Creator III

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.

datalakeyu
Specialist
Specialist

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.

arasantorule
Creator III
Creator III

Hi Haikuo,

Can you share the expression you are trying to achieve?

Thanks.

Silambarasan1306
Creator III
Creator III

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.

rgvavihs
Specialist
Specialist

try this

Any selection  made on Filter1 will not be impacted through out the application.

sum({1<Filter1=,>}sales)