Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

master_student
Contributor 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
Honored Contributor III

Re: conditions

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

Re: conditions

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