Re: create a reports for price analysis for a products from various websites
1. Make sure that all your tables are linked to each other correctly. Qlik Sense uses the field names of the tables as keys. If two tables have fields with the same names then those fields will be used to link the tables. Once your tables are linked correctly you can use the fields with the website names and hotel names as chart dimensions. Create a Table chart and use Hotel name and Website name as dimensions and sum(price) as measure.
2. Add another measure like avg(rating) to the Table chart
3. No, a combi chart can have only one dimension, not two.
another answer: the date in your Qlik Sense app will not be updated unless you reload the app. There is no real time live connection with the source DB. Only a reload will fetch the data from the source DB.