How to create a single Straight table should dynamically change with different measures.

[sharu055]

Hi All,

I am currently migrating a dashboard from QlikView to Qlik Sense. In QlikView, I have 30 tables that share the same dimension columns, but each table has different expressions (measures).

I would like to know if it is possible in Qlik Sense to create a single table with the common dimensions, and have the expressions (measures) change dynamically based on user interaction—such as clicking a button or making a selection. Ideally, the table would update to show the selected expression without needing to create multiple tables.

If this is possible, could you please advise on the best approach to implement this in Qlik Sense? For example, can expressions be stored and triggered via buttons or drop-downs, and how would I set this up?

Thank you in advance for your help

[Amit_Prajapati]

Hi @sharu055 ,

You can implement a dynamic measure expression in Qlik by following these steps:

1. Create an inline dimension that matches your measure names, such as Sales, Profit, or Revenue.

2. Use this inline dimension in a filter pane, and ensure it allows only one selection at a time.

3. Define your measure expression dynamically using the following syntax:

   count($(='[' & [_Dim] & ']'))

4. This expression dynamically evaluates the selected measure based on the value in the _Dim field.

This setup enables flexible switching between different measures using a single filter control.

[sharu055]

Actually i have a big big expression, can i add them in a measure creation as in below screenshot. Could you please show me with an example how to achieve this. 

[Amit_Prajapati]

Yes you can do it with Master Measure 

[sharu055]

How to apply master measures to a single table, i created 30 master measure and what will expression i should write straight table.