Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vmrkai
Contributor
Contributor

set expression with date filter

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.

 

 

 

1 Solution

Accepted Solutions
bharathadde
Creator II
Creator II

Try this

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

View solution in original post

2 Replies
bharathadde
Creator II
Creator II

Try this

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

vmrkai
Contributor
Contributor
Author

Thank you very much.