Cannot display number of weeks for a certain supplier in a specific category
Hello All,
I am having an issue displaying the number of weeks a product is in a specific category.
As you can see In Table 1, the 1st product 'SAM GXY S3 4G BLA CU' is supposed to be in the category '>50' for 4 weeks. But when I select the product (see table 2), the product is supposed to be in the category '>50' for only two weeks as the other 2 values are 0.
Can you tell me how I can ask Qlikview to return me the correct value, that is, 2 without selecting the product. In fact I should get 2 in table 1 in the column '# of wks in category'?
I have used the following expression to calculate the value '# of wks in category':
=count(IF(aggr($(v_Expression_Sum_Stock_Greater_50) or $(v_Expression_Sum_Stock_No_Distribution),%YEAR_WEEK)<>0,%YEAR_WEEK))
