Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

if condition

is it possible to have like an if condition as below

if(match(country name, then A and B else C

A

B

C  are 3 different values in one table.

10 Replies
YoussefBelloum
Champion
Champion

Hi,

you want to do it on the script or on the charts ?

and A, B and C are values or fields ?

Chanty4u
MVP
MVP

try this

=PICK(Match(CountryName, 'A','B','C') 'A','B','C')

raadwiptec
Creator II
Creator II
Author

it should be in the script only..

Anil_Babu_Samineni

Chanty, What is the use of this? I believe this returns same as from Field

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anil_Babu_Samineni

What you want to do so in script?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

Would you be able to elaborate your requirement with an example?

raadwiptec
Creator II
Creator II
Author

hi all,

I need to hard coded values

is it possible to have like an if condition as below

if(match(country name, France then 'Legal' ,'processed' else 'unauthorized'

The above is working only  for one output ex: legal. i require both..

Legal

processed

unauthorized


are 3 different hard coded values in one table. so when i select country --france in the report in another list box i should see below as 2 different values as because in the data model the below 2 value exists in another linked way

legal

processed.

Anil_Babu_Samineni

on what bases you want to pick one another one? Could u describe more

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful