Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
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