Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sales by Outlet Vs Stock by Warehouse

Dear all,I have the following data:

estimate:

warehouses are : X,Y,Z
Outlets are:         L,M,N

In my filters i have year, month, day , category ,subdivision, OUTLET ,WAREHOUSE.....

I am working to execute the following table:

Table :

                                                    X                                                                                                                  Y

product ID     Stock quantity   Stock Value      Sales Quantity        Sales Amount            Stock quantity   Stock Value      Sales Quantity        Sales Amount

100                                     

200                      

300                      

 

Is it possible to use a function to select an outlet in the filter "example L" , and get  sales quantity and sales value by outlet vs stock quantity and stock value by warehouse.

Regards,

Community Browser