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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

if equals 2 values in a dimension

Hi Experts,

 

in my load script i have an if statement that defines if a po number is  example 'Value A' or 'Value B'

the dimension is named as [We Care].

A PO number can have both values on separate so i can have:

po1234 'Value A'

po1234 'Value B'

 

i have to write an if in the table to state if We Care = value A and Value B the result is value A

however, i cannot associate my effort below to the field PO number

 

=If([We Care] = 'value A' and 'value B' , 'value A','value B')

 

can anyone advise on how i can use the above for all values in a PO number as there is no value of value A and value B in a single cell return.

 

I hope i explained that ok and someone has the answer i'm looking for.

Thanks in advance 

 

Daniel

Labels (1)
0 Replies