Data not filtering when field used as set analysis modifier

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

Hi, hope you can give me an answer to this.

So I have a table and I am trying to separate the records into Current and Over Due. When I try to select a cell on any column except Due Date, the data is filtered correctly. But when I select any record on the Due Date nothing happens. Is it because I used it in the formula in the Text Box? Can someone help me get the correct set analysis script?

Cheers

Current

=num(SUM({$<[Due Date] = {">$(=Date(Today()))"} >}[Amount]), '#,##0.##')

Overdue

=num(SUM({$<[Due Date] = {"<=$(=Date(Today()))"} >}[Amount]), '#,##0.##')

Re: Data not filtering when field used as set analysis modifier

sunny_talwar — Fri, 09 Mar 2018 02:28:21 GMT

Try this

Current

=num(SUM({$<[Due Date] *= {">$(=Date(Today()))"} >}[Amount]), '#,##0.##')

Overdue

=num(SUM({$<[Due Date] *= {"<=$(=Date(Today()))"} >}[Amount]), '#,##0.##')

topic Data not filtering when field used as set analysis modifier in QlikView

Data not filtering when field used as set analysis modifier

Re: Data not filtering when field used as set analysis modifier