Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted

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". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

10 Replies
Highlighted

Re: Set analysis on dimensions

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

Highlighted
Contributor
Contributor

Re: Set analysis on dimensions

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

Highlighted

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". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Highlighted
Specialist II
Specialist 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

Highlighted

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". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
Specialist II
Specialist II

Re: Set analysis on dimensions

ah yes didn't see ;

but not understanding yet why different functionalities between qs and qv

Highlighted
Creator III
Creator 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.

Highlighted

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". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
Contributor
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.