Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead 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])

Thanks in advance

4 Replies

Re: VcurrentYear

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

Re: VcurrentYear

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
Specialist

Re: VcurrentYear

By your expressn:

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
Specialist II

Re: VcurrentYear

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