Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
lfholland
Creator
Creator

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)

View solution in original post

4 Replies
trdandamudi
Master II
Master II

May be as below:

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

mikecrengland
Creator III
Creator III

It should look something like this:

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


Don't forget the quotes...


mike

lfholland
Creator
Creator

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)

bvssudhakar
Creator III
Creator III
Author

All Answers are working, Thank you very much guys