Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
nickmarlborough
Creator
Creator

creating a button

Hi, 

I have fields called 'league' , 'team' , 'member'

Within the field 'member', you either are 'Mapped' or 'Unmapped'  (meaning you are mapped or unmapped to overall ID in question - field callled 'heirarchy'

I want to create x3 different buttons. 

1. a button that selects all the teams where there are no features of any 'mapped' players. in other words, the tag is only 'Unmapped'

2. a button that selects all the teams where there are 'Mapped' players but also an instance of an 'Unmapped' player

3. a button that selects all the 'leagues' where there are 'Mapped' players but also an instance of an 'Unmapped' player

 

Thanks!

Labels (1)
1 Reply
F_B
Specialist II
Specialist II

Hi @nickmarlborough ,

for request number 1 you can use set analysis, something like this: {<member={'Unmapped'}>}

For requests number 2 and 3... well those are more complicated, maybe with the addition of Rand() function? Something similar has already been asked, have a look at this:

Generate Random Data from Specific Values - Qlik Community - 890448

 

Hope this helps you somehow