topic Re: Conditional Expression on Stacked Chart in QlikView

Conditional Expression on Stacked Chart

brucejensen — Wed, 13 Sep 2017 15:36:17 GMT

I have a stacked bar chart where my dimension is Quarter and my Expressions are totals of various departments (Claims, Underwriting, etc.) When a user selects a Department from the multi box, I'd like the chart to change and just show the department selected. The default (no selections) would show all Departments.

From this:

To This:

I accomplished this using WildMatch(Concat([Roll-Up Dept],'/'),'Claims') but it has a couple problems. The default view is an empty chart. You have to select a Dept to view it. I'd like the default to show all depts. (the full stack like above). And it won't let me select multiple depts. I've seen this work on a table but can't get it to work on the stacked chart. Any help would be greatly appreciated!

Re: Conditional Expression on Stacked Chart

sunny_talwar — Wed, 13 Sep 2017 15:40:28 GMT

What is your expression

Re: Conditional Expression on Stacked Chart

sunny_talwar — Wed, 13 Sep 2017 15:43:33 GMT

Are you using set analysis on Department field? If you are, then you might need an asterisk before your equal sign

Implicit Set Operators

Sum({<Department *= {...}>}Measure)

Re: Conditional Expression on Stacked Chart

brucejensen — Wed, 13 Sep 2017 15:59:21 GMT

The expressions are Sum(Claims), Sum(Underwriting), etc. to make up the individual parts of the stack

Re: Conditional Expression on Stacked Chart

brucejensen — Wed, 13 Sep 2017 16:00:50 GMT

No b/c each expression is a dept itself. Sum(Claims), Sum(Underwriting), Sum(CCC)

Re: Conditional Expression on Stacked Chart

sunny_talwar — Wed, 13 Sep 2017 16:09:55 GMT

I would suggest to use The Crosstable Load to convert each department into a single column.... but with your current structure, you can use this for your conditional expressions.... for instance for Sum(Claims), use this:

=SubStringCount(Concat(DISTINCT '|' &[Roll-up Dept]) & '|', '|Claims|')

Re: Conditional Expression on Stacked Chart

brucejensen — Wed, 13 Sep 2017 19:11:57 GMT

This worked perfectly! Thank you so much!