topic Re: Show and sum values from person by year in QlikView

Show and sum values from person by year

Thu, 24 Jan 2013 11:14:36 GMT

Hello,

A question from a Qlikview personal edition user. I'm using an Oracle database with 2 tables which looks like the follow: (keep in mind that this is just a small part of it, the actual tables have many more rows and columns:

FCL_NUMMER	Pers_ID	YEAR FROM	YEAR TILL
6162031	12	2008	2010
6162031	11	2011	2020

FCL_NUMMER	Year	EUR Payed	EUR income
6162031	2009	€ 500,00	€ 300,00
6162031	2012	€ 2.500,00	€ 4.500,00
6162031	2010	€ 500,00	€ 300,00
6162031	2013	€ 2.500,00	€ 4.500,00

Now i want a listbox with the following fields: Pers_ID, Year, EUR Payed, EUR Income. And a chart with the SUM of the EUR Payed and EUR Income of a Pers_Id by Year.

So i need something like only show values from Pers_ID when Year is in YEAR FROM / YEAR TILL, or maybe something else? Does someone know how i can solve this problem?

I hope im clear, if u have any questions, just ask. 🙂

Re: Show and sum values from person by year

khadeer — Thu, 24 Jan 2013 11:22:00 GMT

write the following expression in ur dimension(Pers_Id) , Just edit that dimension in dimension tab,

if(Year=YEAR FROM or Year=YEAR TILL,Pers_ID)

and dont forget Surpress when value is null check box, if u dont want to display other ID's.

Send an excel sheet with some fields with respective value.

Let me know if any issues.

Re: Show and sum values from person by year

Thu, 24 Jan 2013 11:55:12 GMT

Hi,

Thanks for your quick response, i did some changes to your expression (the Year >= YEAR FROM and <= YEAR TILL) and it works now! Thanks for the help. 🙂