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.

[Marijn]

Hi,

You can create a variable input with all the options for different calculations in a dropdown. This will change a variable which you can then use in an expression to show a specific calculation.

The expression would look something like this:

if( '$(vVariable)' = 1, expression1,

if( '$(vVariable)' = 2, expression2, etc...

[hugo_andrade]

@sharu055 ,

Qlik Sense has an object that actually does this natively and might address your needs.

Use the Straight Table, and activate Chart Exploration on the Appearance menu.

Leave the Editing view. 

Then it will show the Chart Exploration menu next to your straight table. From here, you can enable/disable the columns easily. Make changes to the Columns on the Data menu item (edit mode).

[Nagaraju_KCS]

We have several ways to approach this. Let's consider a scenario with three buttons and 30 expressions. When a user clicks a button, it needs to display the corresponding 10 expressions. and same for the other two buttons.

• Add all dimensions and expressions to the chart.
• Create a variable and apply it to control the dimensions and expressions.
• Based on the button click, the expression should be enabled (by applying the variable's value in the show condition).

Other way: if you have two buttons USD and EUR, you can switch the expression based on selection. 

=Pick(WildMatch(%Currency, 'USD', 'EUR'), '[Budget USD]', '[Budget EUR]')

Hope this helps