topic Re: How to filter out rows on straight table? in QlikView

How to filter out rows on straight table?

mandilicious — Tue, 23 Apr 2019 13:22:00 GMT

Hi All

Please help I would like to display only where Type = 'Current' in this straight table.

Thanks

sunny_talwar — Tue, 23 Apr 2019 13:25:50 GMT

May be use set analysis in your expression to show only Type = 'Current'

Sum({<Type = {'Current'}>} Measure)

mandilicious — Tue, 23 Apr 2019 14:16:41 GMT

Thanks Sunny perfect.

mandilicious — Tue, 23 Apr 2019 14:26:26 GMT

Hi Sunny

How can I filter in table box as well?

Thanks

sunny_talwar — Tue, 23 Apr 2019 14:29:55 GMT

To do this in table box, you will have to make a selection in Type field to select Current