Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mfarslnn
New Contributor

Set analysis on dimensions

Hello everyone,

I have an app that lists stores and its informations. Stores has its brands and sectors. And store brand is on the filter panel.

When I choose a store on filter panel, i want to list all the stores which in the same sector with the selected store. I can achieve this with set expressions but when it comes to using same logic for dimensions it didn't work.

Any help will be appreciated.

Tags (1)
1 Solution

Accepted Solutions
Lech_Miszkiewicz
Honored Contributor III

Re: Set analysis on dimensions

Just like Sunny said it needs to be done in script, but it is easy....


why don't you just create second store/sector table and make your sector field a key field to link it with sector form your current store table.


when selecting store you will filter sector just via association and this association would then link to your second store/sector table in which you would say"store name 2" field listing all stores from filtered sector.

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
10 Replies
MVP
MVP

Re: Set analysis on dimensions

You will need to make script modifications to make this to work...

mfarslnn
New Contributor

Re: Set analysis on dimensions

Can you help me for how to do that? Or can you share a sample qvd if possible?

Lech_Miszkiewicz
Honored Contributor III

Re: Set analysis on dimensions

Just like Sunny said it needs to be done in script, but it is easy....


why don't you just create second store/sector table and make your sector field a key field to link it with sector form your current store table.


when selecting store you will filter sector just via association and this association would then link to your second store/sector table in which you would say"store name 2" field listing all stores from filtered sector.

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
ogautier62
Valued Contributor II

Re: Set analysis on dimensions

Hi,

an idea without script modification :

add two actions :

- action on selection in field store :

  selection on field sector with value = only({$} sector)

- then new action : deselect field store

that works

regards

Lech_Miszkiewicz
Honored Contributor III

Re: Set analysis on dimensions

Looks like we are talking about Qlik Sense - so no triggers, unless you are using extensions...

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
ogautier62
Valued Contributor II

Re: Set analysis on dimensions

ah yes didn't see ;

but not understanding yet why different functionalities between qs and qv

kaanerisen
Contributor III

Re: Set analysis on dimensions

Hi Fatih,

If I understand your need correctly, you can use p() modifier in set analysis.

Sample Data:

Untitled.png

Expression:

sum({<Sector=P(Sector),Store=>}Value)

Output:

Untitled2.png

Hope it helps.

Lech_Miszkiewicz
Honored Contributor III

Re: Set analysis on dimensions

Hi Kaan,

From what i read in the question Fatih knows how to do it iwth set analysis on expression - question though was in regards to dimension...

We all know that this can become little bit hazy when used as calculated dimension...

cheers

L.

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
mfarslnn
New Contributor

Re: Set analysis on dimensions

Hi Kaan,

Thanks for reply.

As Lech said i need to implement this logic on the table dimension. Its basically a sector and store analysis. I have other pivot tables in which i can see my selected store's informations. And i want to see my store's performance within its sector and compare selected store with their values.

Community Browser