I am relatively new to Qlickview and I have some difficulties with the scritping and barchart bits. I have uploaded and excel file containing some tables and fields containing data.One of these tables is called Branches and another one is called Products. The Product table contains two values. "Existing" and "New". Those values are mapped with arround 20 branches from the Branches table.
Now I am trying to make a Stacked Bar chart in Qlickview where Branches table will be the dimension of the chart and the Products the Expression. What i am trying to show is the persentage of the existing and new products within each branch and the difference between those those two. I understand that i need to compare values "new" and "existing" but both values are in one table and i can't really split them in excel, therefore I need to make a conditional Expression that picks the values individually and stackes them in one bar or make two expressions. One containing the New product info and the other one containing the Existing product info.I have attacghed an image as an example from Excel.
Could someone guide me step by step of how to do that?
Thanks for the response!!! All i wanna do is to use the Branches as Ddimension and the Product type as Expression in a stacked bar chart as shown in the previous picture. I want it to show the percentage of the new and the existing products in every branch. (As you see the branches can appear more than once which means that a branch can be associated with more than 1 products). My probelm is that when adding the Expression, i don't know how to reference to the data withn the Product type table because there are two different values Ideally it would sound like "take all the New and Existing fileds associate with the branches and for each branch on the X-axis show me the number of products in percentage. i.e. Branch 17 has 75% of existing products and 25% New products since there are 3 existing and 1 new associated with this branch.. as shown in the picture