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

Anonymous — Sat, 16 Nov 2024 21:51:22 GMT

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

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

Anil_Babu_Samineni — Wed, 21 Nov 2018 03:42:43 GMT

Can you explain little with data?

topic Re: Selecting a column to use as a denominator based off a value selection in App Development

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

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