topic Re: How to create VIEW from SQL in QlikView

How to create VIEW from SQL

sculptorlv — Thu, 17 Dec 2015 14:57:48 GMT

Hello. Please help with information.

There is CREATE VIEW function in SQL.

Can I use the same in Qlikview?

I have tabel

Select

From Table 1.

Can I do something like ???

Create VIEW BigTable AS

Select

From Table 1.

oknotsen — Thu, 17 Dec 2015 15:33:00 GMT

Why would you want to do something like this?

buzzy996 — Thu, 17 Dec 2015 15:45:35 GMT

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

sculptorlv — Fri, 18 Dec 2015 06:30:21 GMT

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 — Fri, 18 Dec 2015 11:08:03 GMT

Get the tables into Qlik and do the work there.