Discussion Board for collaboration related to Creating Analytics for QlikView.
I'm sure i'm just missing something simple for this one....
all my dimensions are real dimensions and not calculated. There are no selections made in the doc.
My pivot dimensions are:
the expressions i want are:
may it helps u .plz let me kn
unfortunately not... that just gives me blanks... not sure why you changed it from -12 to 0? i need the sales from the same month a year ago
Check sale_date and InMonth(sale_date,SaleMonth,-12)
Does it return the same format?
inmonth returns a boolean but my understanding is that inside a set it will just return all the sale_date that match so in theory should return the sales from the previous year's month.
the dollar sign expansion suggested by rohit214 i suspect doesn't work because of the format you've mentioned
i m sorry for that
using salemonth-1 means to get the data previous yaer
may it helps you
i believ you need to calculate monthYear in script from Date using below
Monthname(date) as MonthYear
the n use expression
hope this help
that just gave me $0... I changed yours to -12 from -1 as i want the previous year.
rohit214 - your example looks like it would only return the previous month, not the same month from the previous year...
share the sample fil so that i can have a look.
put -12 in place of -1