Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Folks,
I have a script with a measure made from the CONCAT keyword
Concat([Team Type], ', ', -Weight)
With the following dummy script
Cities:
Load
City as '%_city',
* Inline
[
City
Philadelphia
New York
Pittsburgh
]
;
TeamType:
Load
City as '%_city',
[Team Type],
Weight
Inline
[
City, Team Type, Weight
Philadelphia, Baseball, 23
New York, Baseball, 45
Pittsburgh, Baseball, 19
Philadelphia, Basketball, 8
New York, Basketball, 71
]
;
Exit Script
;
When I select Basketball I get the following:
What I want to see is even though Basketball is selected, all the other Team Types are still brought in. Below is what I am trying to get to.
City | Concat([Team Type], ', ', -Weight) Team Types List |
New York | Basketball, Baseball |
Philadelphia | Baseball, Basketball |
You see that even though the selection is Basketball, Baseball is still brought in. I've tried Concat({1}...) but that didn't work and ignored ALL selections.
Any help is greatly appreciated
maybe like this?
Concat({$<City=p(),[Team Type]>} [Team Type], ', ', -Weight)
You can use 1 of 2 flavors of Set Analyis.
The first ignores ALL your filters: Concat({1} [Team Type], ', ', -Weight)
The second will ignore only the filter on team type but honor any others: Concat({<[Team Type]=>} [Team Type], ', ', -Weight)
Check out this post I created about Set Analysis and download the PDF in the post: https://community.qlik.com/t5/Qlik-Sense-Documents/Making-Sense-of-Section-Access-in-Qlik-Sense/ta-p...
Hello @Dalton_Ruer ,
I've tried those two Set Analysis queries. They didn't work because when you select Basketball, the query ignores the selection and continues to bring in Pittsburgh that only has a Baseball team.
Hi @JustinDallas ,
Maybe this:
aggr( {1} concat( {1} [Team Type], ', ', -Weight ), City )
I hope it can helps.
Best Regards
maybe like this?
Concat({$<City=p(),[Team Type]>} [Team Type], ', ', -Weight)
Hello @MarcoWedel ,
It works like a charm. I understand that the City=P() means "look at all possible cities". But what does the "Team Type" in the following term do?
Concat({$<City=p(),[Team Type]>}
Glad it worked.
[Team Type]
in this case is like
[Team Type]=
meaning selections in field [Team Type] should be ignored (equal sign is not strictly necessary).
hope this helps
Marco