topic Re: Current Year and Last month selection in QlikView

Current Year and Last month selection

Fri, 28 Aug 2015 07:13:48 GMT

Hello Friends,

I want the current year selection in callender and previous month selection.

So can any one tell me how to do this, as I have done for current year through sheet properties trigger but what about previous month selection how to give previous month selection.

Thanks,

Ashish

Re: Current Year and Last month selection

crusader_ — Fri, 28 Aug 2015 07:29:11 GMT

Hi,

Use below expression in search string:

=Month(AddMonths(today(),-1))

EDIT: Add new trigger to your existing Year selection which will select in field Month within above SearchString.

Regards,

Andrei

Re: Current Year and Last month selection

Marcellino_Groothof — Fri, 28 Aug 2015 09:13:29 GMT

Hi,

Write in the script:

LET CY = year(today());

LET CM = month(today())-1;

then in a expressie: sum ({$<year={$(CY)},month={$(CM)},>} amount)

Regards

Re: Current Year and Last month selection

kavita25 — Fri, 28 Aug 2015 09:51:00 GMT

Try the below expression for previous Month trigger.

Sheet properties >> On Activate Sheet >> Selection >> Select in Field >> Field- Date Field >> Search String

month(MonthStart(Max(Date_Field),-1))

Re: Current Year and Last month selection

Fri, 28 Aug 2015 10:31:29 GMT

Thank you, Kavita and Marcellino for your response but its not working with your exp.

n the correct ans is

=Month(AddMonths(today(),-1))

Re: Current Year and Last month selection

Fri, 28 Aug 2015 10:35:39 GMT

Thank you very much Andrei, for your response. its working with your exp.

Re: Current Year and Last month selection

kavita25 — Fri, 28 Aug 2015 10:38:22 GMT

My expression was based on date field..

If you have date field and use the expression given by me, will surely work...

Re: Current Year and Last month selection

Fri, 28 Aug 2015 10:59:07 GMT

Ok sure...Thanx....