topic Opening Balance in QlikView

Opening Balance

Localbar — Mon, 17 Dec 2018 09:43:58 GMT

Hi all,

I am new in Qlikview, Just want to know that can do as below

	2015	2016	2017	2018
Opening Balance	0	75	80	106
No. of Issue	100	100	100	100
No. of Redemption	25	50	33	39
No. of Expired	0	45	41	22

Thanks

Re: Opening Balance

Mark_Little — Mon, 17 Dec 2018 09:48:43 GMT

Hi,

Most likely. But you need to share more information about the data to give a definitive answer.
What does the base data look like?

Mark

Re: Opening Balance

Anil_Babu_Samineni — Mon, 17 Dec 2018 09:58:49 GMT

For me this is like just Transfer from Column to Row using Pivot table for Year field? What is your question?

Re: Opening Balance

sergioskv — Mon, 17 Dec 2018 12:42:22 GMT

HI mate
First of all u need to ask right questions 🙂
This is straight table or pivot?
You need to create a char with YEAR as dimension and ROWS as expressions.

Sergio S.