Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can I filter a measure on a line chart "sum value1 where value2 != [selected value2 in filter pane]"

Hi,

I was wondering if it were possible to have a filter pane and line chart on the same sheet.  When a value is selected in the filter pane I want the measure in my line chart to sum a total some column in my DB where a value does NOT EQUAL the value from the selected filter pane.  I am using #1 below to get a total count of story points based off of the selection in the filter pane (sprint) right now so I would like something like #2 below.

1.  Sum({$<project={'Project_NAME'}>}story_points)

2.  Sum({$<project={'Project_NAME'}>   AND sprint != [Selected sprint from filter pane]      }story_points)

I hope this makes sense and any help would be much appreciated.  Thank you.

2 Replies
Anonymous
Not applicable
Author

Sorry I would also need it to be based on todays date as well


Sum({$<project={'Project_NAME'}>   AND sprint != [Selected sprint from filter pane]   AND date is today   }story_points)

OmarBenSalem

Maybe :

Sum({$<project={'Project_NAME'}   ,sprint=E(),   date={"$(=today())" }>}story_points)