topic Re: Mapping Year in QlikView

Mapping Year

renjithpl — Wed, 02 Jan 2013 12:41:12 GMT

HI All,

i have a table like;

AccountOpen	OpenYear	ClosedYear
AA1	2009	2012
AA2	2010	2012
AA3	2011
AA4	2012

So in my front end, i would like to have a chart with dimension as OpenYear (which is my base year) and in expression would be the count of accounts closed

in the above table two accounts have been closed in the year 2012,

so my graph should say,

OpenYear	Accounts Closed
2012	2

how can i achive this

Re: Mapping Year

Gysbert_Wassenaar — Wed, 02 Jan 2013 13:02:35 GMT

Use ClosedYear as dimension instead and count(ClosedYear) as expression.

Re: Mapping Year

renjithpl — Wed, 02 Jan 2013 13:44:34 GMT

I cant use as its mandatory here, and my application is huge and has other impacts..