topic Re: how it works here in QlikView

how it works here

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

Hi all,

how this variable works

vNoOfMonthsDisplay =12

vMonth=Num(AddMonths(Date(Max([Month Year])),-vNoOfMonthsDisplay)) ==this how works?

sunny_talwar — Mon, 19 Mar 2018 11:13:53 GMT

It takes the Max(Month Year) and takes it back 12 months. Not exactly sure what you are not clear about...

PrashantSangle — Mon, 19 Mar 2018 11:20:15 GMT

If you want to learn exact functionality of each function which use in your expression go to help menu

max()

addMonths()

date()

and Num()

Note : In your expression you can avoid Date()

Regards,

shiveshsingh — Mon, 19 Mar 2018 11:49:14 GMT

=Num(AddMonths(Date(Max([Month Year])),-12))

You are pulling max from the [Month Year] field and then going 12 months back, post this you are converting it to Num format.

Anonymous — Mon, 19 Mar 2018 11:50:17 GMT

Hi,

With my understand of expression, The code will roll-out for 12 months.

Ex: If you want to show case last 12 months trend from current month this code will helps.

Thanks,

Venkata Sreekanth