Opening Balance

[Localbar]

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

[Mark_Little]

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

[Anil_Babu_Samineni]

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

[sergioskv]

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.