How to create VIEW from SQL

[sculptorlv]

Hello. Please help with information.

There is CREATE VIEW function in SQL.

Can I use the same in Qlikview?

I have tabel

Select

A

b

c

From Table 1.

Can I do something like ???

Create VIEW BigTable AS

Select

A

b

c

From Table 1.

[oknotsen]

Why would you want to do something like this?

[buzzy996 · Accepted solution]

qlikview won't support,first create a view in ur sql it self and call that view from qliview,tht helps.

[sculptorlv]

Thank you for answers.

I just have one SELECT (multiple joines).

And now I would like to get one MAX(values) group by .... from this SELECT.

Can't insert this MAX within SELECT itself - got mistake

[oknotsen]

Get the tables into Qlik and do the work there.