topic Re: How to write the Set Analysis Formula to avoid list box selection in QlikView

How to write the Set Analysis Formula to avoid list box selection

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts,

I have an Expression: =Sum([Total No. of Openings])- Sum(Placed)

Now i want to show that output for only one particular selection and it will show same result whatever selections we select that means i want avoid list box selection

For that i wrote like this but it's wrong, can you guys please give correct expression

=Sum({<{([Total No. of Openings])-(Placed)},[Job Status]={Open},StatusofJob={Billable}>}

Job Status, StatusofJob both are list boxes

Thank you in advance

Re: How to write the Set Analysis Formula to avoid list box selection

trdandamudi — Thu, 09 Aug 2018 14:29:39 GMT

May be as below:

=Sum({1<[Job Status]={'Open'},StatusofJob={'Billable'}>} [Total No. of Openings]-Placed)

Re: How to write the Set Analysis Formula to avoid list box selection

mikecrengland — Thu, 09 Aug 2018 14:31:45 GMT

It should look something like this:

=Sum({<[Job Status]={'Open'},StatusofJob={'Billable'}>}Total No. of Openings])

Don't forget the quotes...

mike

Re: How to write the Set Analysis Formula to avoid list box selection

lfholland — Thu, 09 Aug 2018 14:38:40 GMT

I would try what Michael suggested and doing the same with Placed:

=Sum({<[Job Status]={'Open'},StatusofJob={'Billable'}>}[Total No. of Openings])

Sum({<[Job Status]={'Open'},StatusofJob={'Billable'}>}Placed)

Re: How to write the Set Analysis Formula to avoid list box selection

bvssudhakar — Fri, 10 Aug 2018 06:15:47 GMT

All Answers are working, Thank you very much guys