topic Manage Expressions With VBMarco in QlikView https://community.qlik.com/t5/QlikView/Manage-Expressions-With-VBMarco/m-p/1282041#M856103 <HTML><HEAD></HEAD><BODY><P>They need a chart that summarizes the workload of a department by month, dividing into "past", "current" and "forward" the work done.</P><P></P><P>So I have written my cute script that builds the expression string (it's just a count) searches in my document for <SPAN style="font-size: 13.3333px;">the proper chart, checks whether an expression is already in in order to remove it, and recreates the expression. Then I check periods and set the expression label.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Of course i did it to keep it rolling, so what is now current, will be in the past next month and so on. The number of expressions will increase of 1 per period as times goes by.</SPAN></P><P></P><P>I have read that it cannot be done at reload on the server.</P><P></P><P>Taking for granted that all the authorizations have been set correctly, how do I do it?</P><P></P><P>EDX? AJAX? Ideas?</P><P></P><P>Kind Regards, thanks in advance,</P><P>Gianfranco.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Manage Expressions With VBMarco https://community.qlik.com/t5/QlikView/Manage-Expressions-With-VBMarco/m-p/1282041#M856103 <HTML><HEAD></HEAD><BODY><P>They need a chart that summarizes the workload of a department by month, dividing into "past", "current" and "forward" the work done.</P><P></P><P>So I have written my cute script that builds the expression string (it's just a count) searches in my document for <SPAN style="font-size: 13.3333px;">the proper chart, checks whether an expression is already in in order to remove it, and recreates the expression. Then I check periods and set the expression label.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Of course i did it to keep it rolling, so what is now current, will be in the past next month and so on. The number of expressions will increase of 1 per period as times goes by.</SPAN></P><P></P><P>I have read that it cannot be done at reload on the server.</P><P></P><P>Taking for granted that all the authorizations have been set correctly, how do I do it?</P><P></P><P>EDX? AJAX? Ideas?</P><P></P><P>Kind Regards, thanks in advance,</P><P>Gianfranco.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Manage-Expressions-With-VBMarco/m-p/1282041#M856103 2020-11-25T16:16:04Z