This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a pivot table and the user selects a month and a year
in the pivot table I want to display the for each customer that value of the invoices whose date is the maximum before the selected month
i.e. if the user selects 2016,OCT then I want to calculate the sum of the Sales amount of the invoices whose date is before OCT 2016
customers may have invoices last invoiced on Apr 2015 others may have the last invoice dated on Sep 2016 and so on
Can you be able to share some raw data with the expected output to help you better? It will be pure guesswork without a sample as its difficult to understand what you are trying to get
Pardon my ignorance, but should the below simply work?
=sum(if([Transaction Date] < MakeDate(vYear, vMonth,1) ,Value, 0))
with vMonth and vYear the selected month and year
No not this way
what I want is calculate the amount of the invoices whose date is the maximum date for each customer and is just before the selected date