Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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