topic Re: Variable error in QlikView

Variable error

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created an variable in script but it is showing an script error,but i have tested the same in text object its working fing fine.

Please find the below error.

Variable : let vCurr_Month_Year = month(monthstart(max(ActivityDate-1)))&' '&(year(max(ActivityDate-1)));

Thanks..

Re: Variable error

tresB — Wed, 26 Oct 2016 12:00:04 GMT

Yes it would work in the UI but not in the script. Let me explain why. The problem is max() in your expression. You can't use any field using aggregation function in variable declaration in the script like that. They can only be used in a load statement.

You may rather try something like:

Load

Max(AcivityDate) as MaxDate

From <>;

Let vMaxDate=Num(Peek(MaxDate))-1;

let vCurr_Month_Year = month(monthstart($(vMaxDate))&' '&(year($(vMaxDate)));

Edit: Corrected the field name

Re: Variable error

Anil_Babu_Samineni — Wed, 26 Oct 2016 12:01:36 GMT

What is your intend to show?

Re: Variable error

sunny_talwar — Wed, 26 Oct 2016 12:04:22 GMT

May be try with SET instead of let:

SET vCurr_Month_Year = month(monthstart(max(ActivityDate-1)))&' '&(year(max(ActivityDate-1)));

Re: Variable error

gireesh1216 — Wed, 26 Oct 2016 12:25:28 GMT

Hi Naresh,

Activate date is not use directly in let function.

do one thing

create two variables in front end:

vA1=month(monthstart($(vMax))-1);

vA2= year(date($(vMax)))-1;

Then open text box object use below expression

=vA & vB

It will working fine

Thanks

Gireesh

Re: Variable error

gireesh1216 — Wed, 26 Oct 2016 12:28:18 GMT

This function also not working...

Re: Variable error

nareshthavidishetty — Wed, 26 Oct 2016 12:28:20 GMT

Hi,

I think set wont help.

Thanks..

Re: Variable error

tresB — Wed, 26 Oct 2016 12:34:37 GMT

I have corrected the field name in the post above. Now give a try.

Re: Variable error

gireesh1216 — Wed, 26 Oct 2016 12:45:14 GMT

Create three variables in front end using variable overview

vA=month(monthstart($(vMax))-1);

vA= year(date($(vMax)))-1;

vCurr_Month_Year =vA & vB

Then open text box object use below expression

=vCurr_Month_Year

working fine in my system

Re: Variable error

nareshthavidishetty — Wed, 26 Oct 2016 12:45:16 GMT

Hi,

What is vMax ?

Thanks..

Re: Variable error

nareshthavidishetty — Wed, 26 Oct 2016 12:49:57 GMT

Hi,

vMax = ?

Thanks..

Re: Variable error

sunny_talwar — Wed, 26 Oct 2016 12:51:21 GMT

You want the variable to evaluated in the script? or do you want to bring it as an expression?

Re: Variable error

rubenmarin — Wed, 26 Oct 2016 13:18:31 GMT

Hi Naresh, I think the solution provided by tresesco should work, there is one parenthesys left:

LET vCurr_Month_Year = month(monthstart($(vMaxDate)))&' '&(year($(vMaxDate)));

Just to comment, why a month(monthstart(maxdate))?, I think it should be the same as Month(maxdate), no need for the monthstart.

Re: Variable error

nareshthavidishetty — Wed, 26 Oct 2016 13:20:05 GMT

Hi,

The current variable is static like it give only month(max(today()) but now we need it as dynamic so that based on the year it should be react..

Thanks..

Re: Variable error

rupamjyotidas — Wed, 26 Oct 2016 13:23:09 GMT

I don't know your intent here but if you want to find out currentmonthyear

try this below code

temp_Min_Max_Dates:

LOAD

Min(YourDate) as MinDate,

Max(YourDate) as MaxDate

RESIDENT FWRSData

;

Let vMinDate = Num(Peek('MinDate', 0, 'temp_Min_Max_Dates'));

Let vMaxDate = Num(Peek('MaxDate', 0, 'temp_Min_Max_Dates'));

Drop Table temp_Min_Max_Dates;

//Current Date

Let vReportCurrentDay = 'Day($(vMaxDate))';

Let vReportCurrentMonth = 'num(Month($(vMaxDate)))';

Let vReportCurrentYear = 'Year($(vMaxDate))';

Re: Variable error

gireesh1216 — Wed, 26 Oct 2016 14:08:40 GMT

vMax=max(ActivityDate)

Re: Variable error

nareshthavidishetty — Wed, 26 Oct 2016 14:55:19 GMT

Hi,

Please let me know the below that variable is not working and is there any way to get this.

let vMax=MonthName(max(ActivityDate));

Thanks..

Re: Variable error

rubenmarin — Wed, 26 Oct 2016 15:00:22 GMT

Hi naresh, tresesco explained why that can't work in the first answer... and how to solve it.

Re: Variable error

nareshthavidishetty — Wed, 26 Oct 2016 15:14:43 GMT

Hi,

I have used the approach but it gives only the max month but i need dynamic month based on the filter selection.

Thanks..

Re: Variable error

rubenmarin — Wed, 26 Oct 2016 15:19:28 GMT

If the value needs to be calculated in front-end you can use this variable:

=Text(Date(Max(ActivityDate), 'MMM YYYY'))

and you can define the variable in script as:

SET vCurr_Month_Year = "Text(Date(Max(ActivityDate), 'MMM YYYY'))";