Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could some one please help in providing the below logic in a sample QVW:
Regards!
Suppose your expression is Sum(Sales) and suppose your SAles Date in the transactions is Date
then for previous month:
sum({< Year=,Month=,Date={"$(=num(DayStart(Addmonths(Date(max(Date)),-1))))"}>}Sales)
Last 13 Months
sum({< Year=,Month=,Date={">=$(=num(DayStart(AddYears(Date(max(Date)),-1))))"}>}Sales)
these num(dayStart are needed in case your dates values are numbers(QlikView format)
Hi Ali,
Thank you for the help.
Could you please show this in a sample QVW please?
give me a sample data and I will write the expressions for you
sorry I don't have sample data from my side
Hi Ali,
Attached is the sample set of data. Please help me with a sample QVW
Hi All,
Any help on this request please?
Regards,
Dicky Mohanty
Check attached document
elaborate more if this is not what you exactly want
sorry for the late reply
Hi Ali,
Thank you for the help.
Can it be shown in some graphical way, may be line chart or something else?
Alos, how the Current Month vs. Previous Month calculations can be displayed?
check attached document
check attached document