topic Re: Detaching Individual Selections in QlikView

Detaching Individual Selections

Anonymous — Wed, 30 Mar 2016 12:37:39 GMT

I am creating a text box within a dashboard with a count function within.

I require this function to be based on all of the current selections apart from the date fields.

In other words I want to detach it from all calendar based selections, but remain attached to all others.

Re: Detaching Individual Selections

oknotsen — Wed, 30 Mar 2016 15:00:05 GMT

Lets assume your count function currently is "count(OrderID)" and you want to exclude the fields Year and Quarter from having effect on this expression. If so, this is how the expression would look like:

= count({$ < Year=, Quarter= > } OrderID)

The extra curly brackets that you see and everything in between is something called "Set Analysis". You can manipulate the data set used for your expression with using that. Search for Set Analysis for a lot more information.

Re: Detaching Individual Selections

sunny_talwar — Wed, 30 Mar 2016 20:46:38 GMT

Another option could be this:

=Sum({<$(='[' & Concat({<$Table = {'MasterCalendar'}>}$Field, '],[') & ']')>}Sales)

NOTE: The above will show syntax error in expression editor, but will work as expected

Re: Detaching Individual Selections

oknotsen — Wed, 30 Mar 2016 21:18:51 GMT

Thanks for that trick, sunindia‌. I sure am going to make some customers happy with that.

Re: Detaching Individual Selections

Anonymous — Thu, 31 Mar 2016 07:45:23 GMT

Thank you. This was the simplest solution.

I am a newcomer, but am aware of set analysis.