Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

warrentk80
New Contributor III

SET Analysis disregard the current selections

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

1 Solution

Accepted Solutions
MVP
MVP

Re: SET Analysis disregard the current selections

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)

2 Replies
MVP
MVP

Re: SET Analysis disregard the current selections

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)

warrentk80
New Contributor III

Re: SET Analysis disregard the current selections

It is exactly what I wanted through 1000

really nice

Community Browser