Discussion Board for collaboration related to Creating Analytics for QlikView.
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!
List box selection works fine when I tried with your sample data set.xlsx. Maybe try building the chart again.