Ok, I'm a newbie so here goes my first question in QlikView. I am trying to create a table or chart that will help me analyze data. I have what I think should be the dimension (Year) and multiple expressions (Products 1/2/3/4). When I create the table or chart, it only allows me to select dimension (Year). I don't want that, I want to select any expression that contains "1" as the value. I'd like to make a decision on which expression to analyze by the largest number of values of "1" for that Product. Note; the expression fields only contain a "0" or "1." The raw dataset looks something like the below:
Year
Product 1
Product 2
Product 3
Product 4
2015
0
0
1
0
2015
1
0
1
1
2015
0
1
1
1
2015
1
0
1
1
2015
1
0
1
1
Essentially, I want the final table to look like the below. I want to be able to click on the Sum of the Products individually; 3, 1, 5 or 4 and select those records for analysis in another table. I tried to move the Products into the dimension (so that I could select them) and the Year to the expression but I get Dimension Calculation errors when I try to Sum each of those fields. I would appreciate if someone could advise. Thanks.
Thanks for the prompt response Santiago. Except I'm not clear with the table mock up. My table looks like the one I described above where Product 1, Product 2, Product 3 and Product 4 are different fields/columns, each containing values '0' or '1'. So, I don't have a table with a singular 'Product' column and separate Qty column. Does that make sense what I'm trying to do ?
