topic SET Analysis disregard the current selections in QlikView

SET Analysis disregard the current selections

warrentk80 — Tue, 27 Oct 2015 13:07:28 GMT

Goodmorning everyone

I made a dash with three objects of type object where calculating the sum of the budgets of all customers of the agent A, agent B and C Agent

to make the sum in the three use the box setAnalysis.

num = (sum ({$ <[Agent] = {'A'}>} [Budget] / 1000000), '### 0,0')
num = (sum ({$ <[Agent] = {'D'}>} [Budget] / 1000000), '### 0,0')
num = (sum ({$ <[Agent] = {'C'}>} [Budget] / 1000000), '### 0,0')

I also have a histogram graph type where you do the analysis for applying the agent also filter text objects take the filter and then displays only the value associated with the selection.

I would rather that regardless of the solution BOX visualizzassero text data.

It is possible via SET Analysis disregard the current selections?

Thanks for collaboration

Andrea

Re: SET Analysis disregard the current selections

swuehl — Tue, 27 Oct 2015 13:20:24 GMT

Not sure what you exactely want.

If you want to disregard the current selection, you can use set identifier 1:

sum ({1 <[Agent] = {'A'}>} [Budget] / 1000000)

Or if you want to regard the user selection in Agent, use the intersection set operator *:

sum ({$ <[Agent] *= {'A'}>} [Budget] / 1000000)

Re: SET Analysis disregard the current selections

warrentk80 — Tue, 27 Oct 2015 13:29:22 GMT

It is exactly what I wanted through 1000

really nice