Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Stacked Bar Chart Filtering

Is there a way for me to make a filter/set expression/etc so that when I select "Submitted" in my filter, all employees without a submission disappear, and the employees with a submission stay *INCLUDING* their proper approved expense. 

Raw Bar Charts

If I do a standard filter, I keep employees with new submissions but lose their prior approved expenses. leaving me with just this months expenses and not a year to date expense.

If I do a set analysis, the employees with no submission stay in the chart and are greyed out but I get to keep my total year expense for employees with submissions.  if I have 1000 employees I don't want the user to have to scroll to check each.

 

I essentially need a set analysis to identify that they have a submission and to keep their total year expense based on the filter selection, and I need the filter selection to also remove those who fail to meet the criteria. 

thanks!

0 Replies