topic Re: Error working with variables in App Development

Error working with variables

MaryanVegaC — Mon, 15 Aug 2022 19:21:11 GMT

Hello,

I have an input variable (V1) where the default value is 2022-05. And I wanna create a subsequent variable to create a range of months from V1. Here it is what I`m trying to do:

Addmonths($(v1),-11)

the expected value should be 2021-06, eleven months earlier, but instead I`m getting 1904-08. Somebody can help me, I don`t understand why Qlik is changing the value. something important is that in the data load editor the date format is SET DateFormat='YYYY-MM';

Thank you

Re: Error working with variables

Digvijay_Singh — Mon, 15 Aug 2022 21:02:09 GMT

Looks like $(V1) is not interpreted as date, this works -

Addmonths(Date('$(V1)','YYYY-MM'),-11)

Re: Error working with variables

rwunderlich — Mon, 15 Aug 2022 23:51:53 GMT

@Digvijay_Singh I think you mean Date# ?

-Rob

Re: Error working with variables

Digvijay_Singh — Tue, 16 Aug 2022 02:23:51 GMT

@rwunderlich

My bad, actually interpretation is not needed as the format is 'YYYY-MM' is updated in the script as mentioned by @MaryanVegaC .

Addmonths('$(V1)',-11) - This also works, so Date/Date# are not needed

Re: Error working with variables

MaryanVegaC — Tue, 16 Aug 2022 12:55:08 GMT

Thanks @rwunderlich and @Digvijay_Singh for your help 🙂