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: 
Not applicable

set analysis exclude based on records in field

Hi all

I am trying to sum a column but would like to do this only where it does not equal 'No: addendum' in another field. The total seems to work ok however it does not seem to display properly in the charts.

Sum({ $ - <IncludeMasterImagingTable={'No: Addendum'}>} [No of exams])

Any help would be much appreciated.

Thanks

Dan

9 Replies
Not applicable
Author

Try this below one

Sum({<IncludeMasterImagingTable -={'No: Addendum'}>} [No of exams])

Not applicable
Author

it does not seem to like the - character. am i putting it in wrong?

Not applicable
Author

it is - character only. when i`m poste formulae with set analysis it apears like underscore. its is chr(45).

- Sridhar

Not applicable
Author

HI Sirdhar

It does not seem to be working still. I may have to revist this tommorow and as a quick work around just set them to 0.

tahnsk for your help

Dan

Not applicable
Author

Hi,

Check out the working example with this post.

You could do this by 2ways. Your expression would be as follows.

Sum({<IncludeMasterImagingTable -={'No: Addendum'}>} [No of exams])

or

Sum({<IncludeMasterImagingTable ={"=IncludeMasterImagingTable<>'No: Addendum'"}>} [No of exams])

Hope this helps you.

- Sridhar

Not applicable
Author

It still will not work. It must be something wrong with how i have it set up. I am going to have to get the bottom of this tommorow as what you have proposed obviosuly works fine!!!

Thanks for all your help and i will come back to the post tommorow.

Dan

Not applicable
Author

Daniel, Post your sample data here, we will also check this for you.

- Sridhar

Not applicable
Author

Here we go. I have jsut taken a subset and put it into excel. Basically i have a total activity box which dispalys the total activity summary of the current selections. I also have a chart with the dimension of 'exam code' and expresion for the total activity.

total activity = the sum no.exams but excluding ''No: Addendum'

Thank you so much for your time.

dan

Not applicable
Author

Daniel,

Not sure why all my below expressions doesnt give values . Very odd.

Sum ({<IncludeMasterImagingTable = {"*"}-{"*Addendum*"} >}[No of exams])

or

Sum ({<IncludeMasterImagingTable -= {"No: Addendum"} >}[No of exams])

or

Sum ({<IncludeMasterImagingTable = {"=len(IncludeMasterImagingTable) = 0"} >}[No of exams])

Can you change in back end when IncludeMasterImagingTable field <> No: Addendum then give some flag and use that as filter to get your data.

But need to investigate and understand why all my expression not giving valaue (can some here please explain me to undersand this odd behaviour )

Sample application is attached with this post.

Thanks in advance

- Sridhar