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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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