Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mfarslnn
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.

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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
sunny_talwar

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

mfarslnn
Contributor
Contributor
Author

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

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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.
ogautier62
Specialist II
Specialist II

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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.
ogautier62
Specialist II
Specialist II

ah yes didn't see ;

but not understanding yet why different functionalities between qs and qv

kaanerisen
Creator III
Creator III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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.
mfarslnn
Contributor
Contributor
Author

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.