topic View Queries in QV in QlikView

View Queries in QV

Mon, 06 May 2013 04:12:30 GMT

Hello Experts-

I am very new to Qlikview tool and have been trying to learn it from last 1 month or so.

I have 2 questions :

a. could you please tell me where i can find the queries that are being fired in the background in the qlikview. i would like to take the query and run, say, expalin plan in toad to view the stats.

b. could you please let me know the best place(website, tutorials) to learn in detail architecture of QV like the config files and more on it...

Thanks in advance.

Regards, Bhupendra

Re: View Queries in QV

Sokkorn — Mon, 06 May 2013 04:38:32 GMT

Hi Bhupendra,

Here is some idea

a. You can find script by Ctrl+E or click on Edit Script

b. You are on the best place community.qlik.com and you try this ebook. Anyhow, you can check QlikView Manual here and here.

Regards,

Sokkorn

Re: View Queries in QV

Mon, 06 May 2013 04:44:43 GMT

Thanks Sokkorn for quick help.

this helps, but this particular feature gives me the script or the data model for the application.

Rather am looking for the query that report generates, for example...

Suppose there are 3 tables t1, t2 and t3 and if the user comes in select 2 columns from each table, so i want to know the query that got fired for the particular report...

pls suggest..

thanks again

Re: View Queries in QV

Sokkorn — Mon, 06 May 2013 04:56:33 GMT

Hi Bhupendra,

Maybe attachd file can help you.

Regards,

Sokkorn