Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
Champion
Champion

Opening and closing stock for Every month

Dear All

I want to generate following type of chart  and I am attaching the excel sheet opnclosing.xls which is having

all the data opening stock data + receipts data - issue data = closing for that month for only one product

EXPECTED OUTPUT
AS PER SELECTION OF FINANCIAL YEAR
CYCLOPAMOPN STKTOT RECTOT ISSUECLOSING
APR25405002002840
MAY2840300503090
JUN3090120001500090
12 Replies
kaushiknsolanki

Hi,

     In your excel sheet the Total issue and Total Receipt have same data.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
vikasmahajan
Champion
Champion
Author

Thanks sir , I am modifying same and replace the same please seek your guidance

Vikas

vikasmahajan
Champion
Champion
Author

Dear Sir

I have modified excel sheet please reply for this post ?

abeyphilip
Creator II
Creator II

Hi Vikas,

I am not sure I understood your issue correctly.

Made couple of changes in your QVW (in load and the front end expressions) based on my understanding.

Please see if this is what you are looking for. If not, please explain more on the expected output.

Regards,

Abey

vikasmahajan
Champion
Champion
Author

Thanks for Reply I want  This is for one month this way I want to summary  April to March along with closing balances.

MonthOPENING STOCKTOTAL RECTOTAL ISSUE COLUMN(1)+COLUMN(2)-COLUMN(3)
Aug1880378492104547350352066388
vikasmahajan
Champion
Champion
Author

Dear Sir ,

Following are my expression when I put in opening bal. column values are appering other than aug month also I want single line Please refer attached jpg.

SUM({$<FinancialYear=,Quarter=,MonthName=,[Posting Date] ={"<$(=Monthstart(min([Posting Date])))>=01/04/2012"},Inv_Doc_Type_FLAG={'OPSTK'}>}INVQTY)  /* Closing Qty of prev month*/

Awaiting for your reply.

Vikas

vikasmahajan
Champion
Champion
Author

Dear Sir

Any luck on this issue ?

Vikas

kaushiknsolanki

Hi,

Here is the solution.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
vikasmahajan
Champion
Champion
Author

Thanks Sir,

I will get back you after checking .

Vikas