topic Re: set expression with date filter in QlikView

set expression with date filter

vmrkai — Fri, 13 Dec 2019 16:13:30 GMT

Hi everyone

I have some question about filter pane and set expression.My set expression is "sum({$<[Start Year]={"2017"}>}[Avg Out])" .It's show the correct answer but when i add a filter pane with start date my set expression is show zero.How i can fixed it.

Re: set expression with date filter

bharathadde — Fri, 13 Dec 2019 20:54:52 GMT

Try this

sum({1<[Start Year]={"2017"}>}[Avg Out])

Re: set expression with date filter

vmrkai — Fri, 13 Dec 2019 23:50:05 GMT

Thank you very much.