topic VB functions in qlikview in QlikView https://community.qlik.com/t5/QlikView/VB-functions-in-qlikview/m-p/153683#M30630 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>it is possible to use a user function i wrote in vb, as an expression in qlikview, for example this function</P><P>i would like to use it in the sort expression of a pivot.</P><P><BR />Function StageOrder(StageID As Integer) As Integer</P><P>Dim Value As Integer<BR /> Select Case StageID<BR /> Case 1<BR /> Value = 1<BR /> Case 9<BR /> Value = 2<BR /> Case 10<BR /> Value = 3<BR /> Case 11<BR /> Value = 4<BR /> Case 2<BR /> Value = 5<BR /> Case 3<BR /> Value = 6<BR /> Case 4<BR /> Value = 7<BR /> Case 5<BR /> Value = 8<BR /> Case 6<BR /> Value = 9<BR /> Case 7<BR /> Value = 10<BR /> Case 8<BR /> Value = 11<BR /><BR /><BR /><BR /> End Select<BR /><BR /> StageOrder = Value<BR />End Function</P><P></P><P>thanks,</P><P>shlomo</P></BODY></HTML> Thu, 21 Oct 2010 22:44:11 GMT m4u 2010-10-21T22:44:11Z VB functions in qlikview https://community.qlik.com/t5/QlikView/VB-functions-in-qlikview/m-p/153683#M30630 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>it is possible to use a user function i wrote in vb, as an expression in qlikview, for example this function</P><P>i would like to use it in the sort expression of a pivot.</P><P><BR />Function StageOrder(StageID As Integer) As Integer</P><P>Dim Value As Integer<BR /> Select Case StageID<BR /> Case 1<BR /> Value = 1<BR /> Case 9<BR /> Value = 2<BR /> Case 10<BR /> Value = 3<BR /> Case 11<BR /> Value = 4<BR /> Case 2<BR /> Value = 5<BR /> Case 3<BR /> Value = 6<BR /> Case 4<BR /> Value = 7<BR /> Case 5<BR /> Value = 8<BR /> Case 6<BR /> Value = 9<BR /> Case 7<BR /> Value = 10<BR /> Case 8<BR /> Value = 11<BR /><BR /><BR /><BR /> End Select<BR /><BR /> StageOrder = Value<BR />End Function</P><P></P><P>thanks,</P><P>shlomo</P></BODY></HTML> Thu, 21 Oct 2010 22:44:11 GMT https://community.qlik.com/t5/QlikView/VB-functions-in-qlikview/m-p/153683#M30630 m4u 2010-10-21T22:44:11Z VB functions in qlikview https://community.qlik.com/t5/QlikView/VB-functions-in-qlikview/m-p/153684#M30631 <HTML><HEAD></HEAD><BODY><P>No, you cannot call Vb user functions from a chart expression. You can call them from script.</P><P>You can provide similar function in several ways.</P><P>1. Sort by expression and use a match expression:</P><P>=match(StageID, 1,9,10,11,2,3,4,5,6,7,8)</P><P>2. Load an inline table with<BR />StageID, StageSort</P><P>And then use =StageSort as your sort expression.</P><P>-Rob</P></BODY></HTML> Fri, 22 Oct 2010 00:48:02 GMT https://community.qlik.com/t5/QlikView/VB-functions-in-qlikview/m-p/153684#M30631 rwunderlich 2010-10-22T00:48:02Z