topic Why does my formula work in a Chart Object but not in the Script in QlikView https://community.qlik.com/t5/QlikView/Why-does-my-formula-work-in-a-Chart-Object-but-not-in-the-Script/m-p/178197#M45488 <HTML><HEAD></HEAD><BODY><P>Nick,</P><P>Thank you for your help, I just added your attached to my script and now the lables are correct in the New field titled 'Non Spa' however the Sales amounts are now all the same which shouldn't be the case. .</P></BODY></HTML> Thu, 20 Jan 2011 22:16:14 GMT 2011-01-20T22:16:14Z Why does my formula work in a Chart Object but not in the Script https://community.qlik.com/t5/QlikView/Why-does-my-formula-work-in-a-Chart-Object-but-not-in-the-Script/m-p/178195#M45486 <HTML><HEAD></HEAD><BODY><DIV>I have a field named Reporting Level that contains the following record categories:</DIV><DIV></DIV><DIV>SPA</DIV><DIV>Parts</DIV><DIV>Accessories</DIV><DIV>Demo SPA</DIV><DIV>Other</DIV><DIV>Freight</DIV><DIV></DIV><DIV>I am only concerned with records that are not SPA, Demo SPA or Freight, as a result, i created the below formula as a calculated Dimension called [Non Spa], and in my pivot table chart , i can select suppress Null Values and then my chart displays exactly what i want.</DIV><DIV></DIV><DIV>=IF([Reporting Level]='Spa',isnull,IF([Reporting Level]='Demo Spa',isnull,IF([Reporting Level]='Freight',isnull,[Reporting Level])))</DIV><DIV></DIV><DIV>However, i dont want to have to add the above calculated dimension into every chart that i create, so i decided to build this into the script to make this calculated dimension a NEW dimension</DIV><DIV></DIV><DIV>but, this formula doesnt work. Why not and is there another solution. I have just started to learn set analysis so i have not been able to put the above into set analysis.</DIV><DIV></DIV><DIV></DIV><DIV>any help is greatly appreciated.</DIV></BODY></HTML> Thu, 20 Jan 2011 20:47:31 GMT https://community.qlik.com/t5/QlikView/Why-does-my-formula-work-in-a-Chart-Object-but-not-in-the-Script/m-p/178195#M45486 2011-01-20T20:47:31Z Why does my formula work in a Chart Object but not in the Script https://community.qlik.com/t5/QlikView/Why-does-my-formula-work-in-a-Chart-Object-but-not-in-the-Script/m-p/178196#M45487 <HTML><HEAD></HEAD><BODY><P>Here is your NoSpa</P></BODY></HTML> Thu, 20 Jan 2011 21:26:39 GMT https://community.qlik.com/t5/QlikView/Why-does-my-formula-work-in-a-Chart-Object-but-not-in-the-Script/m-p/178196#M45487 2011-01-20T21:26:39Z Why does my formula work in a Chart Object but not in the Script https://community.qlik.com/t5/QlikView/Why-does-my-formula-work-in-a-Chart-Object-but-not-in-the-Script/m-p/178197#M45488 <HTML><HEAD></HEAD><BODY><P>Nick,</P><P>Thank you for your help, I just added your attached to my script and now the lables are correct in the New field titled 'Non Spa' however the Sales amounts are now all the same which shouldn't be the case. .</P></BODY></HTML> Thu, 20 Jan 2011 22:16:14 GMT https://community.qlik.com/t5/QlikView/Why-does-my-formula-work-in-a-Chart-Object-but-not-in-the-Script/m-p/178197#M45488 2011-01-20T22:16:14Z