Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
croyer
New Contributor

Selecting a column to use as a denominator based off a value selection

I'm creating a graph that I need to change based on the selection being chosen.

 

  • I have a table with many events, I will call my Event Table. Each has a unique ID number and it has a Location column where the events happen.
  • I also have a Denominator Table that is organized by the column Month-Year. There is a unique value for each Month-Year and for every row, let's say Jan 2016, there are different columns based off of Location  information that I will need to use as a denominator in order to create summaries for the Event Table on a Month-Year basis.
  • I would like to automate this as much as possible where if I select a Location (from the Event Table) on a drop down menu on the Qlik Sense Dashboard, it will use that selection to automatically change a graph to select the right column in the DenominatorTable to divide the Count # of Events for that specific Location

I am having trouble trying to find that right language (unsure if GetFieldSelections will work) to match a column based off a selection. I am envisioning something similar to Index/Match in Excel but I am unsure where to start looking

Labels (4)
1 Reply

Re: Selecting a column to use as a denominator based off a value selection

Can you explain little with data?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)