Previous month condition

[Prabhu1204]

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

[sergio0592 · Accepted solution]

Hi,

You can try with previous function in the preceding load

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