topic Re: Can I set a variable in Chart Dimension? in QlikView https://community.qlik.com/t5/QlikView/Can-I-set-a-variable-in-Chart-Dimension/m-p/856635#M1016865 <HTML><HEAD></HEAD><BODY><P>I don't see why this shouldn't be feasible, could you provide us with the dimensions and their calculated (expressions) you have?</P></BODY></HTML> Fri, 17 Apr 2015 14:37:39 GMT petter 2015-04-17T14:37:39Z Can I set a variable in Chart Dimension? https://community.qlik.com/t5/QlikView/Can-I-set-a-variable-in-Chart-Dimension/m-p/856634#M1016864 <HTML><HEAD></HEAD><BODY><P>I calculate a value based upon two other record values. Here is an example:</P><P>round(60*24*(10000*Num(CallTime) - left(subfield(date#(CreationDate),'.',2),4))/10000)</P><P></P><P>The issue is that I want to add 720 if it is less than -270 and then set to null if it is still less than 0 or more than 270.</P><P></P><P>I can do this with a bunch of nested if statements in the calculated dimension but it will look cumbersome and be error prone if I need to make changes. Is there a place where I can calculate the value for each record and then refer to it by the variable name? I tried to do it in the load but didn't have much luck. I thought it would be more logical to define it in the dimension but it didn't seem possible. Not sure which approach is best.</P><P></P><P>On a somewhat unrelated note I also was surprised that Median was not an option when totaling values for expressions. Of course I wanted to get the Median for the calculated dimension which doesn't seem doable.</P></BODY></HTML> Fri, 17 Apr 2015 14:14:19 GMT https://community.qlik.com/t5/QlikView/Can-I-set-a-variable-in-Chart-Dimension/m-p/856634#M1016864 2015-04-17T14:14:19Z Re: Can I set a variable in Chart Dimension? https://community.qlik.com/t5/QlikView/Can-I-set-a-variable-in-Chart-Dimension/m-p/856635#M1016865 <HTML><HEAD></HEAD><BODY><P>I don't see why this shouldn't be feasible, could you provide us with the dimensions and their calculated (expressions) you have?</P></BODY></HTML> Fri, 17 Apr 2015 14:37:39 GMT https://community.qlik.com/t5/QlikView/Can-I-set-a-variable-in-Chart-Dimension/m-p/856635#M1016865 petter 2015-04-17T14:37:39Z Re: Can I set a variable in Chart Dimension? https://community.qlik.com/t5/QlikView/Can-I-set-a-variable-in-Chart-Dimension/m-p/856636#M1016866 <HTML><HEAD></HEAD><BODY><P>So this is the expression used in the calculated dimension:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">round(60*24*(10000*Num(CallTime) - left(subfield(date#(CreationDate),'.',2),4))/10000)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CallTime is a string and CreationDate is a datetime. <BR /></SPAN></P></BODY></HTML> Fri, 17 Apr 2015 14:54:24 GMT https://community.qlik.com/t5/QlikView/Can-I-set-a-variable-in-Chart-Dimension/m-p/856636#M1016866 2015-04-17T14:54:24Z