how to get previous month results based on selection

kavitha_kommise — Thu, 11 Oct 2018 13:11:46 GMT

hello,

i have requirement to show previous month results based selection,

if i select April then it has to show mar results how can i achieve

can any one help me to built set expression

thanks and regards,

kavitha

Re: how to get previous month results based on selection

kavitha_kommise — Thu, 11 Oct 2018 13:38:41 GMT

hello,

i have built a set expression like this

i am getting month based on selection previous month but aggregation is not happening.

it is returning 0 though i have value.

Sum({<DATE = {"=MonthName(DATE) = MonthName(AddMonths(max(DATE), -1))"}>}IN_CHARGE)<DATE = {"=MonthName(DATE) = MonthName(AddMonths(max(DATE), -1))"}>}IN_CHARGE)

MonthName(AddMonths(max(DATE), -1))--this is giving previous month based on selection.

sum({<DATE = {"=MonthName(DATE) = MonthName(Today(), -1)"}>}IN_CHARGE)----this expression working statically

i want set expression in such a way based on current month selection it has to show previous month results.

please help on same

thanks in advance,

kavitha

topic how to get previous month results based on selection in QlikView

how to get previous month results based on selection

Re: how to get previous month results based on selection