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: 
martin_hamilton
Creator
Creator

Only include certain values in straight table

Hi - am using a set analysis in a straight table but it doesnt seem to be filtering out the data.

Am using qliksense.

=only({<Sub_Contract_Status={'Contract Ending'}>}Sub_Contract_Status)

I only want records with a Sub_Contract_Status of 'Contract Ending' to show in the table.

It seems to be showing all records but blanking out the values and I dont know how to filter out these other records.

Thanks

Martin

filterrows.JPG

1 Solution

Accepted Solutions
sunny_talwar

Are there more expressions in your chart? If not, then try to uncheck 'Include Zero Values' under Add-Ons-> Data Handling

View solution in original post

5 Replies
sunny_talwar

Are there more expressions in your chart? If not, then try to uncheck 'Include Zero Values' under Add-Ons-> Data Handling

martin_hamilton
Creator
Creator
Author

There was and this has fixed it, although I also want to have 2 expressions in the chart, would I have to combine it into a single 1 for it to work?

e.g. I only want to include records with a Sub_Status of 'Connected' as well as Sub_Contract_Status of 'Contract Ending'

Thanks

martin_hamilton
Creator
Creator
Author

actually figure that one out myself.

=only({<Sub_Contract_Status={'Out Of Contract'},Sub_Status={'Connected'}>}Sub_Contract_Status)

cheers

Martin

martin_hamilton
Creator
Creator
Author

Thanks for this Sunny appreciated

sunny_talwar

Super