topic Where is the path to keep generated sql statment based on user selecte criteria in QlikView

Where is the path to keep generated sql statment based on user selecte criteria

Wed, 13 Jul 2011 06:00:29 GMT

I would like to know where is the path to keep generated sql statement based on user select criteria , cause seem to be the result is not correct so i'm not sure the join statement is correct or not

Re: Where is the path to keep generated sql statment based on user selecte criteria

Wed, 13 Jul 2011 06:21:03 GMT

Hi,

Please elaborate further or attach a sample app.

Cheers.

Where is the path to keep generated sql statment based on user selecte criteria

kaushiknsolanki — Wed, 13 Jul 2011 06:21:09 GMT

Hi,

The information which you gave is improper.

So please describe with detail and example,

Regards,

Kaushik Solanki

Where is the path to keep generated sql statment based on user selecte criteria

Wed, 13 Jul 2011 06:41:50 GMT

Hi,

Thank you for your kindness, my secario is In the current selection I’m select “Level Name” and the result is show

LevelName Branch

AA KR01

AA KR03

AA BR01

And when I select branch name BR01 it doesn’t show any result , So I would like to know ,

Does qlikview generated sql statement according to criteria or not ,if yes where is it keeps.

Because for other product eg. OBIEE it will generated sql statement of each report in the file NQQuery.log

Thank you

Where is the path to keep generated sql statment based on user selecte criteria

kaushiknsolanki — Wed, 13 Jul 2011 06:50:43 GMT

Hi,

If you want to check the linking is done properly or not,

you can press ctrl +t, which will show you the data model created by qlikview after reloading the script.

another way to open the datamodel is

File -> Table Viewer

Regards,

Kaushik Solanki

Where is the path to keep generated sql statment based on user selecte criteria

Wed, 13 Jul 2011 07:04:16 GMT

for the relation , means that it wil join every tables in the datamodel right ?

e.g i have 3 tables

customer.customer_id,

customer.name

order.customer_id,

order.qty

order.product_id

product.product_id,

product.product_name

if in my report has columns

customer.name, order.qty ---> this will join customer,order or wil join customer,order,product

Thank you

Re: Where is the path to keep generated sql statment based on user selecte criteria

kaushiknsolanki — Wed, 13 Jul 2011 07:19:34 GMT

Hi,

Ok let me exaplain what will happen in this scenario.

As you said you have 3 tables. Lets go through by creating script., so your script will look like.

Customer:

Load Customer_ID, Name from Cutomer;

Order:

Load Customer_ID, Qty, Product_ID;

Product:

Load Product_ID, Product_Name;

Now when you run this script you will get the data model as shown below.

Customer will be linked with Order through Customer_ID

and Order will link with Product with Product_ID

Regards,

Kaushik Solanki