topic Re: conditions in QlikView

conditions

master_student — Thu, 13 Jul 2017 10:01:17 GMT

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

prma7799 — Thu, 13 Jul 2017 10:07:33 GMT

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 — Thu, 13 Jul 2017 10:13:45 GMT

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