Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Qlik Sense SaaS Dimension, Variable & If-Else

Hi Experts,

I'm working on a KPI but the problem is that I wanted to be flexible that the user can click on a selection and the dimension of all the charts will be replaced by the dimensions corresponding to the user's selection.

I'm using a 'Variable Input' object to store the selection of the user into a Variable.

Then, the variable will be my condition in an if-else statement inside the Dimensions Fx.

Here's a sample of that expression:

=If(vDimensionSelection = 'Books',  BookNames,
if(vDimensionSelection = 'Cars', CarBrands,
if(vDimensionSelection = 'Fruits', FruitNames,
if(vDimensionSelection = 'Country', CountryNames))))

Thank you in advance!

10 Replies
Champion III
Champion III

kindly close the thread by accepting a response as solution

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.