Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
Hi Alex,
You can load database view in select form, in left side you can check view to use in your script.
Hi Alex,
In script editor --> below side --> Button Select --> Select Statemet Windows --> Left Side
You cannot create Views in Qlikview. - Ram