topic Re: How to use a selected value out of Query result in another Query in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

trdandamudi — Thu, 19 Jul 2018 21:40:22 GMT

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

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

Anonymous — Fri, 20 Jul 2018 15:36:33 GMT

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 !