table with only part of the fields

[chriscools]

Hello,

i have a huge excel table with al the ordered amounts for example:

line 1= year 2009 , month 1  , order , amount

line 2= year 2010 , month 1  , order , amount

line 3= year 2009 , month 2  , order , amount

line 4= year 2010 , month 2  , order ,  amount

now i want to make in qlikview the following table

column 1 = month

column 2= the amounts but only from year 2009

column 3= the amounts but only from year 2010

i can't do it with a pivot table because i wan't to include include a 4th column where i can see a % from 2010 vs 2009.

now my question is:

because there a multiple orders each month (thank god 🙂 ) i work with the formula sum (amount) to get the amount for all orders for that month.

but how do i exclude al the orders from year 2010 in column 2 where i only want the year 2009.

can anyone give me an idea?

thanx  a lot!

grtz,

chris

[patricio · Accepted solution]

You can use one expression for each year:

Expression 1 with label 2009: Sum(If(Year=2009, Amount))

Expression 2 with label 2010: Sum(If(Year=2010, Amount))

[chriscools]

thanx! that works perfectly!

now i also tried this for a list box but that doesn't seem to work...

with your previous answer i made a tabel showing amounts for year=2010 and country='France'.

in the listbox i want to show the not al the salespersons but only those who are linked to our french clients.

i tried in the expression field of the list box: country = 'France'

but it still gives me everyone...

is there a similar way to narrow down a list box?

grtz