how to calculate opening stock depending on closin... - Qlik Community

suvechha_b · ‎2013-08-23

how to calculate both Opening stock and Closing Stock from one field?

Closing Stock = sum(Closing_stock) of Jul 2013 i.e 10000

Opening Stock = 10000 of Aug 2013

i.e the value I get as Closing Stock of Jul 2013 is same as Opening Stock of Aug 2013

eg,

July 2013 Aug 2013 Sep 2013 Oct2013

Opening Stock 0 10000 5000 0

Closing Stock 10000 5000 0 2000

I am calculating Closing Stock as Sum(closing_stock) . the table has only one value closing_stock , depending on closing_stock I have to calculate Opening Stock.

ashwanin · ‎2013-08-23

Make chart and take the months in Rows with expression same as mentioned by you.

it will provide you the required information.

rgds

Ashwani

Report Inappropriate Content · ‎2013-08-23

Hi,

See the attachment.

CELAMBARASAN · ‎2013-08-23

Can you tell me how your data structure looks like?. Is something like this

Month OpeningStock ClosingStock

Jan 2013 10000 50000

Feb 2013 60000

Mar 2013 70000

If not can you provide the sample data?

suvechha_b · ‎2013-08-23

its like this:

July 2013 Aug 2013 Sep 2013 Oct2013

Opening Stock 0 10000 5000 0

Closing Stock 10000 5000 0 2000

Report Inappropriate Content · ‎2013-08-23

Hi,

Please find the attached file. Hope it helps you

Thanks and Regards,

Amuthabharathi.S

michael_maeuser · ‎2013-08-23

for closing stock use your standard expression and givt it a name (e.g. ClosingStock): sum(Closing_stock)

and for opening stock try: sum(Closing_stock) + above(ClosingStock)

suvechha_b · ‎2013-08-23

I want in this format:

July 2013 Aug 2013 Sep 2013 Oct2013

Opening Stock 0 10000 5000 0

Closing Stock 10000 5000 0 2000

how to calculate opening stock depending on closing stock?

Report Inappropriate Content · ‎2013-08-23

Hi,

You only need to put the check mark on Horizontal under presentation tab.

See the updated attachment.

Report Inappropriate Content · ‎2013-08-23

Hi,

See the attachment whcih is what you are expecting. isn't it?