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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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
MVP
MVP

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