# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for
Did you mean:
Highlighted
Not applicable

## VcurrentYear

Hi all i have a variable  which like this

vCurrentMonth= Max[Month No]

And month No is a column name which has 4,5,6,7,8,910

Now i want to know what does this variable means ? and what does it do

2.

What doeas the below expression does can some one explain me please

=Sum({\$<Year={\$(=Max(Year))},[Month No]={\$(=vCurrentMonth)}>}[Sales Amount])

4 Replies
Highlighted
MVP

vCurrentMonth= Max[Month No]

this variable returns the maximum value for the column 'month No'

=Sum({\$<Year={\$(=Max(Year))},[Month No]={\$(=vCurrentMonth)}>}[Sales Amount])

this expression returns the sum of Sales Amount where Year is the max year selected and month no is the current month

Highlighted
MVP

Hi,

The expression calculates [Sales Amount] for current month or current year if the max year in table is 2015 month is Jan

Regards

Anand

Highlighted
Specialist

It will return the Sum of [Sales Amount] where year is equals to maximum of year and Month is MAximum of month as in your case if Month's values are:

1, 2 , 3 4, 5 , 6 , 7 ,8 9, 10 then [Month No]={\$(=vCurrentMonth)} will return Month = 10 always.

thanks

Highlighted
Specialist II

Hi Wrestler,

vCurrentMonth= Max[Month No]....(Month No)->4,5,6,7,8,910

This will takes maximum value from the Month No field.I.e; it will retrieve 10 from the field.

=Sum({\$<Year={\$(=Max(Year))},[Month No]={\$(=vCurrentMonth)}>}[Sales Amount])

This shows the total sales amount of  maximum year from your year field and Maximum month from your Month Field.

Regards

Krishna