topic Re: Sorting values in QlikView

Sorting values

Thu, 09 Aug 2012 13:03:19 GMT

So If you look at my sample it will be easier to understand what I'm trying to do.

I want to create a button that will display all the users that have at least 1 'A' in the any of the "transaction" columns that you see in my sample.

So if someone had, in the following order, A A P A P (or any combination of A's and P's), then they should be displayed. However, if they have P P P P P, then they shouldn't show up after activating the button.

Re: Sorting values

Fri, 10 Aug 2012 13:22:01 GMT

anyone have any ideas?

Re: Sorting values

daveamz — Fri, 10 Aug 2012 14:38:50 GMT

Hi ethanjbeau,

See the example attached.

Regards,

David

Re: Sorting values

Fri, 10 Aug 2012 17:23:59 GMT

Thanks for the sample. I tried to follow it and make all my variables one, then call that in the button and choose whats excluded but the button doesn't work.

Re: Sorting values

Fri, 10 Aug 2012 17:31:08 GMT

Nvm, got it to work!