topic Re: Only include certain values in straight table in QlikView

Only include certain values in straight table

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

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

sunny_talwar — Mon, 11 Jun 2018 12:42:32 GMT

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

martin_hamilton — Mon, 11 Jun 2018 12:51:51 GMT

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 — Mon, 11 Jun 2018 12:59:08 GMT

actually figure that one out myself.

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

cheers

Martin

martin_hamilton — Mon, 11 Jun 2018 12:59:25 GMT

Thanks for this Sunny appreciated

sunny_talwar — Mon, 11 Jun 2018 13:10:15 GMT

Super