2 Replies Latest reply: Feb 24, 2011 4:44 AM by Vikas Singh RSS

    Writing expression to input the date range to display data in the table veiw.

    Vikas Singh

      I am beginner to qlik view . I am facing problem in generating a repor.

      1. i wanted to display two slider contol so as to select to date and from date.

      2. based on this selection i have to display the data in the table view.

       

      Now how should i do that . How to write a script to get the date range in a variable . and how should i have the where condition in the table so as to display the data based on the selected dates.

      sql query is something like this

      select appt_count from

       

      appt'

      where clientid=03

      'and to_char(crdt, 'MM/DD/YYYY')= to_char(sysdate , 'MM/DD/YYYY')"