topic Re: variable in QlikView

variable

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

Hi All ,

Can someone please explain me what does this below two variables do ?

Iam clear about the first variable vReportBegning this will give me last thirteen months data..

I am confised with the second vairable vReportMonthAccumalate ..

Let vReportBegning = Date(MonthStart(AddMonths(Today(),-13)));

Let vReportMonthAccumalate = MonthStart(AddMonths(Date#('$(vReportBegning )'),-1));

I want to get the 13 monhts from the second variable also..

how do i alter the second variable ?

Thanks in advance

Re: variable

tresB — Mon, 20 Nov 2017 07:02:59 GMT

The second variable is equivalent to:

Date(MonthStart(AddMonths(Today(),-14)));

Re: variable

Anil_Babu_Samineni — Mon, 20 Nov 2017 07:03:42 GMT

change 13 to 14 ?

Re: variable

smilingjohn — Mon, 20 Nov 2017 07:20:13 GMT

Hi trsseco ,

if i want to make the second variable vReportMonthAccumalate also to give 13 months ...how do i get it

Re: variable

tresB — Mon, 20 Nov 2017 07:23:22 GMT

The first variable gives that, you can use the same expression or the variable itself.

Re: variable

smilingjohn — Mon, 20 Nov 2017 07:36:35 GMT

Is there a way to get the uouptu for 13 months using the below variable only ?

Let vReportMonthAccumalate = MonthStart(AddMonths(Date#('$(vReportBegning )'),-1));

Because i have to use the first variable in the second as it is the requirement ...

Thanks

Re: variable

tresB — Mon, 20 Nov 2017 07:42:37 GMT

I guess, you better explain your actual requirement here rather than just talking about the variables. It seems that problem could be somewhere else, because trying for different expressions for same expected output doesn't make a lot of sense.

Re: variable

jyothish8807 — Mon, 20 Nov 2017 10:51:17 GMT

Try like this then:

Let vReportMonthAccumalate = $(vReportBegning )

It will give you 13 months again

Re: variable

sasiparupudi1 — Tue, 21 Nov 2017 10:09:19 GMT

in the script

Set vReportBegning = Date(MonthStart(AddMonths(Today(),-13)));

Let vReportMonthAccumalate = 'MonthStart(AddMonths($' &'(=vReportBegning),-1))';

in the UI$(=vReportMonthAccumalate)-$(=vReportBegning)