1 Reply Latest reply: Mar 30, 2015 6:47 PM by t h RSS

    Graph Displays for Filters (with Data Example)

      Hi All,

       

      I am trying to get Quarterly data to filter for three different Types: Firm, Industry, and Market.

       

      There are 4 different amount fields that I would like to display these by: Contacted, Not Contacted, Engaged, and Active.

       

      The idea behind the graph is would be to have a filter (or button with variables) that when I click on say, Industry, bar graphs would display for each Quarter and a stacked bar Graph for the Amounts.

       

      Please find a sample data set attached below:

       

      The idea behind it would look something like the attachment (name: Desired Result), except I would only have one Type showing at once, with all of the Units for that showing as well.

       

      However the filters won't work for some reason (i.e. when I click Market, nothing happens)

       

      I was hoping that someone could take a look at the sample data and let me know what type of expression and dimensions I should use to get this to show the way I want.

       

      My initial thought is I need to use multiple SumIF expressions (i.e. SumIF(Type='Firm') ) or something like that, but I am unfamiliar with using this expression in Qlikview.

       

      Currently I have four expressions to show the breakdown of Contacted, Not Contacted, Engaged, and Active (just SUM(1 of those 4 fields).

       

      Any help at all would be amazing and much appreciated. Feel free to ask for clarification if you need it at all.

       

       

      Thanks in advance!

       

      Ryan