Previous month condition

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

Hello,

I Have a Cal_yr_mo field which has values like 202002

I wanted to write Qlikview SQL function to fetch previous month data without using to_Char function..

Is it possible

Re: Previous month condition

sergio0592 — Thu, 12 Mar 2020 15:53:14 GMT

Hi,

You can try with previous function in the preceding load

LOAD *, Previous(Cal_yr_mo) as prev; SQL SELECT XXX