I am constructing a pivot table in Qlik Sense. I am looking for an expression that counts a piece of string (in my case: "< 12 weeks" or "12 weeks +") and then find the overall percentage for that product.
In my pivot table I have 'product' in the rows. then I will add two measures: (1) to find the percentage of those that are "< 12 weeks" for that product (2) to find the percentage of those that are "12 weeks +" for that product.
So the expression should say, for example, count if "12 weeks +" divide by the total number for product
I can't share the data unfortunately, I have used dummy data in my first post. I have added a new field (Quantity) that I forgot and should have added
So in my dummy data, "apple" can only either be "< 12 weeks" or "12 weeks +" and likewise "banana" and so on. So in my pivot table I need to find the percentage for apple "< 12 weeks" over the total quantity of all of apple in my table i.e. the sum of quantity for apple