1 Reply Latest reply: May 18, 2018 8:35 AM by Wil Verstappen RSS

    how to subquery in a sheet?

    Wil Verstappen

      Hello all,

       

      Hopefully someone can help me with below question:

       

      I'm a newbee in Qlikview, and i've a question about filtering data in a sheet.

       

      I have a live connection with oracle data source. (I've already create a button to refresh data in the sheet)

      I want to create multiple sheets on the same data. Sometimes I only want to see the data of financial year 2018 and in another sheet I want to see the data of financial year 2017 and 2018 together.

       

      How can I make a subquery to see only the data of a specific year?

       

      Capture.JPG

      I thought it should be possible in the Edit expression for that particular field, but I dont know how.

       

      Can I use a where clause in a Edit Expression, or where should I do this to see only data of 2018??

       

      Thanks for support!

      Wil