I have used set analysis as a replacement for alternate states.
I have '%GPA1' ,'%GPA2' filter panes, and 1 'Pillar' filter pane. I want to only allow available 'Pillar' filter selections according to the 2 GPA ranges chosen.
'GPACONCAT' is in my parent table, and '%GPA'(1-2) are my 2 GPA range filter panes. The expression below is for my GPA filter pane. I have tried this expression below, but it only aggregates the 'Pillar' from the second GPA range.
Sorry to not respond earlier. I was looking through your app on sense desktop, but you seem to be using some vizlib extension. I don't really have a way to use them. I was not able to get anywhere. Let me try them on the server version of the sense that I have at work and get back to you.
Oh man, I realised I forgot to remove the vizlib extensions. They are just buttons to other sheets, but I forgot to remove them when preparing the sample qvf file. Please ignore the buttons, and once again thank you very much.