topic Re: VcurrentYear in QlikView

VcurrentYear

Tue, 20 Jan 2015 10:36:30 GMT

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

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

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

Thanks in advance

alexandros17 — Tue, 20 Jan 2015 10:41:11 GMT

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

its_anandrjs — Tue, 20 Jan 2015 10:43:12 GMT

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

nikhilgarg — Tue, 20 Jan 2015 10:55:58 GMT

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

krishna20 — Tue, 20 Jan 2015 10:59:08 GMT

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