topic Re: Run SQL and browser the specific data in QlikView

Run SQL and browser the specific data

Tue, 11 Mar 2014 11:10:55 GMT

I want to do some basic SQL, like data that is between this and that condition whatever, and then I will have this new table where I can browser the specific data.

So I guess I can only do the SQL within the script editor and then ?

Re: Run SQL and browser the specific data

arulsettu — Tue, 11 Mar 2014 11:40:42 GMT

hi -Mikael-

you can write the sql query in script editor. and then if want do more you can write the script in sheet objects also...

Re: Run SQL and browser the specific data

Tue, 11 Mar 2014 12:12:58 GMT

Thx, but the point is that I want to browser the table, that is to review the specific data see how many rows etc.

Re: Run SQL and browser the specific data

Tue, 11 Mar 2014 12:21:05 GMT

Only native tools to look at data within QV are

- the table viewer window (ctrl T)

to see structures:

- create a system table (in an extra sheet).

But if you are a little familar with the user interface it should not be a problem of generating list- and tableboxes

HtH

Roland

Re: Run SQL and browser the specific data

Tue, 11 Mar 2014 12:29:39 GMT

Thx, I know these, but that is not what I am looking for. I just want to test a SQL, with a temp table to look through it. Also the table viewer only gives me the structure with field names? I can then do tableboxes etc. yes, but I did hope for another solution.

System table?

Re: Run SQL and browser the specific data

Tue, 11 Mar 2014 12:37:26 GMT

Yeah,

this is not pretty much, and I was quite sure you know it.

System Table is a predefined object, check it via new sheet object --> System Table (last entry).

But this won't satify your need either.

Re: Run SQL and browser the specific data

Tue, 11 Mar 2014 12:39:50 GMT

BTW:

In your situation I would use a SQL-Client like SQL-Developer or TOAD.