How to create a view

[#1]

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

[Gysbert_Wassenaar]

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.

[#3]

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

regards,

Alex

[#4]

Hi Alex,

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

[#5]

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

regards,

Alex

[#6]

Hi Alex,

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

[#7]

You cannot create Views in Qlikview. - Ram