Create memory variables

[tracycrown]

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

[#2]

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

[tracycrown]

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