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

[#1]

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

[#2]

Hi,

Please elaborate further or attach a sample app.

Cheers.

[kaushiknsolanki]

Hi,

   The information which you gave is improper.

   So please describe with detail and example,

Regards,

Kaushik Solanki

[#4]

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

[kaushiknsolanki]

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

[#6]

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

[kaushiknsolanki]

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