Solved: Re: Creating links between rows of same dimension - Qlik Community

aitmessaoudali · ‎2018-10-24

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 ?

aitmessaoudali · ‎2018-10-24

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

avkeep01 · ‎2018-10-24

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

dplr-rn · ‎2018-10-24

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

aitmessaoudali · ‎2018-10-24

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

avkeep01 · ‎2018-10-24

I've created an example app for you.

aitmessaoudali · ‎2018-10-24

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

avkeep01 · ‎2018-10-24

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

aitmessaoudali · ‎2018-10-24

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

avkeep01 · ‎2018-10-24

There you go.

avkeep01 · ‎2018-10-24

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.