Its a great world qlik is. Its my 3rd day on Qlik and i am able to connect to oracle databse and read tables in it.

[rahulhv1]

Now i need a help, is it possible to have report based on user interaction e.g. User will give me period i.e. from and to date and according to the condition my reports will get changed along with all graphs. I am having 3 tables in oracle data base with below structure

1. Partmaster

    Fields are :  Partno, Partname, Customer

2. Production

    Fields are :  partno, prod.date, qty

3. Sales

    Fields are : partno, saledate qty

I could now connect all these tables and could generate graphs, the only thing i want here is user interaction i.e. user will change the period for the report as per his/her wish and accordinly report should get changed.

[swuehl]

Create list boxes for your dates, so when the user makes a selection, it will filter the charts accordingly.

You can create master calendar tables for your dates (http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar)

so you can offer fields for selection with different granularity (week, month, year etc.).

[Anonymous]

Rahul

Also when in the QV Desktop right click anywhere blank on the dashboard area then:

• New Sheet Object
• Current Selections Box

Then with this object you'll be able what you have selected using the List boxes that swuehl has quite rightly suggested you create.

Best Regards,     Bill

[rahulhv1]

Thanks bill.