How to filter a table

[andy-w]

I have a table containing several columns. I want to filter it, but can't add a filter to the filter shelf. So how do I filter this table?

[jpenuliar · Accepted solution]

perhaps you need a Calculated Dimension?

Example:  

You have a field called Calendar Month that includes each of the months of the year. In your app, you want include a table that shows the sales for each of the first 6 months of the year. For the rest of the months, you want to see a total. You can use an expression to create this calculated dimension.

Syntax:  

If ([Calendar Month] <7, [Calendar Month], 'Rest')

"https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Dimensions/calculate..."

[andy-w]

Thanks, calculated dimension is the way to do it. Shame I can't just put a field on the filter shelf.