Qlik Community

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 
Search instead for 
Did you mean: 
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
Highlighted

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

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

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

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