Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

Text object show/hide in qlliksense

Hi Team,

As shown in the below picture, i have created three text objects.  In variable Overview i have created two variables as vQ1 and vQ2. 

for the first text object - i have given the question and in the Set variable column - > in pick action -> Set variable as vQ1 and value as 1. another Set variable as vQ2 and value as 0. 

Similarly for the second text object as well. however, here set Variable as vQ1 and value as 0, vQ2 value as 1. 

And in the third text object, in show/hide column i have written as

if (vQ1 = 1,'Data quality is so and so', if(vQ2 =1, 'Data governance is so and so','')

Now when i click on first text object, the answer is not displaying in the third text object. it is showing blank. please help me

srujanaponnuru_0-1646836134047.png

 

Labels (1)
4 Replies
Or
MVP
MVP

Your formula is missing a closing parenthesis.

if (vQ1 = 1,'Data quality is so and so', if(vQ2 =1, 'Data governance is so and so',''))

 

 

srujanaponnuru
Creator
Creator
Author

sorry it was a typo error, i have given closing parenthesis. 

srujanaponnuru
Creator
Creator
Author

the logic  i have written is as below

if (vQ1 = 1,'Data quality is so and so', if(vQ2 =1, 'Data governance is so and so'))

Or
MVP
MVP

This formula appears to work correctly. I'd suggest checking if there's something wrong with your variables.

Or_0-1646838888362.png

Or_1-1646838926252.png