topic prior month transaction where code less than 7000 in QlikView

prior month transaction where code less than 7000

Anonymous — Thu, 06 Nov 2014 02:40:00 GMT

what im trying to do is trying to get the straight table to display GL transactions for current month where GLCode is <7000 and also previous months.

currently I have
vPriorMonth =Date(addmonths(max(postingDate), -1,0), 'MMM-YY') // this will give the previous month name and year and

=fabs(sum {$<mySubCode = {'<7000'}>} accountNetAmount )) // this will return all transactions with GLcode less than 7000 and convert the to

how may I combine the two together?

I've tried using

sum ({<MonthYearPosting={'$(vCurrentMonth)'},YearPosting=,MonthPosting=,postingDate=>}accountNetAmount) works same way as sum(accountNetAmount)

this gave me the values for current month, but does not exclude GLCode greater than 7000,

then i tried : sum ({<MonthYearPosting={'$(vPriorMonth )'},YearPosting=,MonthPosting=,postingDate=>}accountNetAmount) this gave me 0

thanks.

djsampat — Thu, 06 Nov 2014 04:45:56 GMT

I think that you want to calculate YTD to the max selected YearMonth.

Try this:

=sum({$<MonthId ={">=1<=$(vMonth)"}>} Volume)

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

Anonymous — Thu, 06 Nov 2014 19:47:04 GMT

gives me same answer as =sum(accountNetAmount)

Anonymous — Thu, 06 Nov 2014 20:31:26 GMT

do i need to create a master calendar for this?

djsampat — Fri, 07 Nov 2014 01:12:26 GMT

Hi,

View this sample YTD

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv