Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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:
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
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
I've created an example app for you.
i can only see the script, i can't see any created dimensions or graphs. thanks
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
yes indeed, i'm using qlik sense. I only need to have dimensions in my table, why go for measures?
There you go.
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.