Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Creator III
Creator III

Create memory variables

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 Replies
Not applicable

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
Creator III
Creator III
Author

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