2 Replies Latest reply: May 6, 2012 2:40 AM by Tracy Crown RSS

    Create memory variables

    Tracy Crown
      Dear all
      Kindly help me on the following as I had tried for two weeks but without an answer:
      1. How to add a NEW row in Group column called Gross profit (Revenue - Cost of sales) below the Cost of sales ?
      2. How to add a NEW row in Group column called Net profit (Gross profit - Operating expenses) below the Operating expenses by using the calcualted memory variable (Gross profit) in 1 ?.
      Please refer to the attached excel worksheet and qv file.
      Thank you
      Tracy
        • Create memory variables
          Anosh Nathaniel

          Hi,

           

          You may need to use the VB script to add a new row dynamically into your Qlikview object. We have done this long back but don't have the VB script.

          May be this guide can help: http://community.qlik.com/docs/DOC-2640

           

          Hope this help,

          Anosh

            • Re: Create memory variables
              Tracy Crown

              Hi Anosh I don't understand how to do it, please help. Thanks a lotTracy

              Date: Sun, 6 May 2012 01:54:15 -0400

              From: qliktech@sgaur.hosted.jivesoftware.com

              To: tracycrown@hotmail.com

              Subject: - Re: Create memory variables

                                                                                              QlikCommunity

                                                       

               

                                                  

                                                  

                                                       

                  Re: Create memory variables

               

               

                  created by anoshnathaniel in New to QlikView - View the full discussion

               

               

               

              Hi, You may need to use the VB script to add a new row dynamically into your Qlikview object. We have done this long back but don't have the VB script.May be this guide can help: http://community.qlik.com/docs/DOC-2640 Hope this help,Anosh

               

               

                   Reply to this message by replying to this email -or- go to the message on QlikCommunity

                   Start a new discussion in New to QlikView by email or at QlikCommunity

                                                                                              © 1993-2011 QlikTech International AB   

                           

                          Copyright & Trademarks | Privacy | Terms of Use | Software EULA