2 Replies Latest reply: Sep 14, 2014 9:59 PM by jagan mohan rao appala RSS

    Use variable with set analysis in Where  condition of SQL

      Hi qlik gurus,

       

      We have a fiscal calendar and a QVD based on that,

      I have a sql query in my qlikview load script in which I want to pass current fiscal period (which is a column in the qvd) in where condition like so- WHERE fiscal_period = '$(vPeriod)'

      and my variable is Let vPeriod = chr(39)&Only({<DATE={"=today()"}>}Period_Name)&chr(39)

      When i load the script and print the variable in Text box I get the resolved value but when i clikc on load script, this perticular query doesnt fetch any rows.

       

      I am not sure why, please help me.