How to use a selected value out of Query result in another Query

[Anonymous]

Hi,

I am very new to the Qlikview tool. Need help in achieving a report that comes based on selection of few other values that are also comes out of simple queries.

1. Need to list out all the products (not many). When user selects a Product (this becomes a variable to next Query)

2. Display only those Stores that this product is available (So I am thinking of using the above selected product in the WHERE clause)

     Let the user select a Store out of the list. (this becomes variable to next Query)

3. Generate a Sales report for that Store

Please suggest what is the best approach to achieve this.

Thanks much !

Chuck

[trdandamudi]

Attached is a sample file with two rows of data and hope this will help.

[Anonymous]

Hi Thirumala

Thanks for your quick response. You are loading the full table data in your example.

But what I need is that the capability to use the selected value in the where clause to pull only required information.

Kind of realtime query execution. Hope I am clear enough. Thanks !