Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How we can find the mode of a dimension value (not key)?

When we use the Mode function it finds the most commonly-occurring value. For working with fact tables it's useful. For example, you can easily find the ID of the most repeated dimension row because the ID exists in the fact table. However, you are going to find the Mode for the name of that dimension, you face a problem. Since the mode function looks at the dimension table and says none of them repeated!

So, how we can find the mode of a dimension value (not key) with respect to how many times it repeated in the fact table?

Labels (1)
1 Reply

Here are some charts showing distribution