Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

conditions

Hello Guys,

I hope all is well

I need your help as usual..

I need to put this conditions in a calculated dimension

If OFFER_TYPE = DATA , FIELD RESTRICTION = Restriction DATA and/or Restriction OTT voix data sauf SS

else  RESTRICTION


Thanks for your help

2 Replies
prma7799
Master III
Master III

You can write this in cal.. dimension

if( OFFER_TYPE = 'DATA'

and

if(  RESTRICTION = 'DATA' or RESTRICTION   = 'Write here ' ) , 'YourField' , RESTRICTION)

If it is not working then please give some more details about your requirement ...

Or share some sample app

Kushal_Chawda

It is not advisable to write the calculated dimension as it consumes a lot memory,

Try to create the Field in script like below

if(OFFER_TYPE ='Data'  or  match(RESTRICTION ,'Value1','Value2'),'Name',RESTRICTION ) as RestrictionNew


Now you can use the RestrictionNew in your dimension