Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted

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)