adding conditions to Variables in Set Command

Krish — Fri, 15 Nov 2024 23:17:03 GMT

Hi,

I am trying to re-use a formula which is used in multiple places in dashboard. I am trying to create a variable which is common across all the places like

sum({<payment={'cash'}>}sales) and create it as a variable vsales = sum({<payment={'cash'}>}sales),

Now I want to add a condition like country='IND' for one chart and country='usa' for other chart, but the calculation is same.

sum({<payment={'cash'},country={'IND'}>}sales) & sum({<payment={'cash'},country={'AUS'}>}sales)

How can I create a variable with common features and re-use them by adding the additional condition based on requirement.

Re: adding conditions to Variables in Set Command

QFabian — Wed, 20 Jan 2021 16:22:41 GMT

Hi @Krish , one option could be use alternate states inside the expressions.

So you can have the same field Country, more than one, but each one referencing to a different State

Please check the qvw

topic Re: adding conditions to Variables in Set Command in QlikView

adding conditions to Variables in Set Command

Re: adding conditions to Variables in Set Command