Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jconsorti
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
jconsorti
Not applicable

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

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
Not applicable

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

Maybe :

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