How to make table like this?

[#1]

Dear All Master Qlik,

I need all of your help to create this table :

Date	Start Stock	IN	OUT	End Stock
01/05/2014	0	235.413	-30.469	204.944

and that upper table have row data like this :

Movement Type	Date	Total
IN	01/05/2014	235.413
OUT	01/05/2014	-30.469

I need to make a column with name "Start Stock" and "End Stock".

Please help me, and thanks for your concern and attention.

Regard's,

Hadi.

[#2]

Dear Mr Kush141087,

Like Mr Jd Sreeni said, it was date of current month, so actually it was month periodic stock not day periodic stock.

Thanks for your concern.

Regard's,

Hadi.

[priyarane]

[#4]

Dear Priya,

Your example is exactly what i mean. how you do that? can you help me with your example.

Many thanks if you could give me your example...

Regard's,

Hadi.

[priyarane]

Hi Hadi,

You can check in my QVW.

[Peter_Cammaert · Accepted solution]

Here with some example data. Does it work ok?

Best,

Peter

[#7]

Dear Priya,

How i can check your QVW? I'm still newbie in this forum, can you explain more detail?

So many thanks..

Regard's,

Hadi

[#8]

Dear Peter,

It does OK, but can you show your QVW ?

So many thanks to you...

Regard's,

Hadi

[Peter_Cammaert]

The QVW was attached to my previous post from the beginning. However, you won't see attachments if you follow this thread via email, mobile phone or in your Inbox.

Open a web browser and navigate to the original thread How to make table like this?

You'll see that Sunil, Priya and myself all have documents attached to their posts. Click on any such attachment, and your browser will start a download of the file.

Note that to open these documents, you'll need a QV Desktop license. That's why we usually post scripts and expressions in this thread as well.

Peter

[#10]

Dear Peter,

Thanks for the explanation, sorry for not know that the file is attach on the post.

So many thanks to you...

Regard's,

Hadi

[Peter_Cammaert]

No problem. Enjoy your time in the Qlik Community.

Best,

Peter