Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Creating links between rows of same dimension

hello community, i have a dimension with the names of clients separated into 5 categories (from 1 to 5 in another dimension), in my dashboard i want to show clients from all categories in separate table. How can i select one client from one table and see the related clients from other categories ?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Contributor

Re: Creating links between rows of same dimension

hey thanks for helping, appreciate it. i think i have found a solution by loading the first table twice and imposing a condition:

table1:

LOAD * INLINE [

id, client_name, category

1,aa,A

2,bb,B

3,cc,A

2,dd,A

4,ee,B

3,ff,A

] ;

tablea:

load id,

client_name as clienta

Resident table1 where category='A';

tableb:

load id,

client_name as clientb

Resident table1 where category='B';

drop table table1;

all i have to do after is create 2 lists one with clienta and the orher with clientb, it works perfectly

View solution in original post

17 Replies
Highlighted
Partner
Partner

Re: Creating links between rows of same dimension

Use P() in your set analysis.

For example: SUM({$<Categorie=P()>} Sales. In that cases all Possible values are shown. Just check this thread for more information:

Set Analysis: syntaxes, examples

Highlighted
Partner
Partner

Re: Creating links between rows of same dimension

you need to use set analysis to do so. A Primer on Set Analysis

Share sample/screenshots of what you have and what you want to achieve. And i can try and help.

Right now its too generic to give a proper answer

Highlighted
Contributor

Re: Creating links between rows of same dimension

in this attached file for instance i want to show 2 lists in my dashboard:

first one: show only clients name of category A

Second one: show only clients name of category b

if i select bb i need to see dd even if they're not from same category but have the same id


Thanks in advance

Highlighted
Partner
Partner

Re: Creating links between rows of same dimension

I've created an example app for you.

Highlighted
Contributor

Re: Creating links between rows of same dimension

i can only see the script, i can't see any created dimensions or graphs. thanks

Highlighted
Partner
Partner

Re: Creating links between rows of same dimension

You're using QlikSense maybe? I'll upload an QVF instead of a QVW for you .

I used;

COUNT({$<client_name=,category=P()>} id) // Possible ID's in category

and

COUNT({$<client_name=,id=P()>} id) //Same ID

Highlighted
Contributor

Re: Creating links between rows of same dimension

yes indeed, i'm using qlik sense. I only need to have dimensions in my table, why go for measures?

Highlighted
Partner
Partner

Re: Creating links between rows of same dimension

There you go.

Highlighted
Partner
Partner

Re: Creating links between rows of same dimension

Because Set analysis works with expressions. Maybe try ONLY({$<client_name=,category=P()>} client_name) and ONLY({$<client_name=,id=P()>} client_name) as calculated dimensions.