topic Re: How to create a view in QlikView

How to create a view

Wed, 22 May 2013 16:11:42 GMT

Hi,

I am populating chart based on data available in one of Oracle schema. That schema is containing view as following

create view v_country_sales as

select countries.country_name, sum(quantity_sold* amount_sold) sales

from sales, customers, countries

where sales.cust_id = customers.cust_id

and customers.country_id = countries.country_id

group by countries.country_name;

I need to create same view in Qlikview but I am not sure how to do it. Can anybody help me in this regard? Thanks.

regards,

Alex

Re: How to create a view

Gysbert_Wassenaar — Wed, 22 May 2013 16:20:00 GMT

Qlikview doesn't have views. You can create a table in Qlikview that contains the data you want.

Country_Sales:

SQL SELECT countries.country_name, sum(quantity_sold* amount_sold) sales

FROM sales, customers, countries

WHERE sales.cust_id = customers.cust_id

and customers.country_id = countries.country_id

GROUP BY countries.country_name;

But if the data from sales, customers and countries tables are already loading into the in-memory database of Qlikview then you should first try to create a chart to display that data your view shows. You could create a straight table with country_name as dimension and sum(quantity_sold* amount_sold) as expression. That's the Qlikview way.

Re: How to create a view

Wed, 22 May 2013 16:22:52 GMT

ok, so how can I load the data without using the view?

regards,

Alex

Re: How to create a view

Wed, 22 May 2013 17:00:44 GMT

Hi Alex,

You can load database view in select form, in left side you can check view to use in your script.

Re: How to create a view

Thu, 23 May 2013 08:05:04 GMT

Thanks, but I am not getting it. Left side of what?

regards,

Alex

Re: How to create a view

Thu, 23 May 2013 14:18:19 GMT

Hi Alex,

In script editor --> below side --> Button Select --> Select Statemet Windows --> Left Side

Re: How to create a view

Tue, 19 Aug 2014 12:11:44 GMT

You cannot create Views in Qlikview. - Ram