Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
QlickySense
Creator
Creator

If statement for multiple variables

Hello,

I have variable A, B, C, D. They all got values ranges from 1 to 4, and all these values have its description

What I would like to acheieve is to keep the var names A, B, C, D but change their labels to 1 - Ok 2- Not bad; 3-Bad, 4-Very bad

Yes I can do that separately for each, but its time consuming because i got plenty of these

I was wondering about something like (for all values but ill present for one) IF(A OR B OR C OR D = 1, 'Ok'). However it does not work because it didnt set it "AS" variable. I'd like to keep A,B,C,D names but change only value because then I have good legend, not 1-4 entries

Any suggestions?

Labels (3)
12 Replies
PiEye
Contributor III
Contributor III

Hi, have just sent a PM - let me know if you get it!

Basically, there's a lot of good stuff out there, we're lucky to have such a good community around us. I would recommend a basic tutorial first, then try a couple of projects on your own.

What I wouldn't recommend are classroom based courses, my experience of them has been that you may as well learn at your own pace but it has also depended on what you are trying to learn (for tutorials and getting started, I dont think its necessary)

Pi

QlickySense
Creator
Creator
Author

Yeah, replied to you 🙂

I have one more question - this one seems to not be applicable to concatenated variable? Just tried and it doesn't seem to work. I guess its need to be mapped to variables from which concatenation starts?

PiEye
Contributor III
Contributor III

True - it will apply to the whole field as it's loaded in. So you might need to load the fields first, then concatenate.