If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hello Everyone,
I've got a question where I cannot seem to find a fitting answer in the community:
In a flat table I display year, product (top 3 products plus others (done with dimension limit)) and sales,
It looks a little something like columns A to C in this picture...
What I need would be a column D that calculates the percentage of sales per product and year...
The total sales per year of the indivual products would have to be calculated and divided by the total of all products per that year.
Is this possible?
Thanks in advance for your consideration and kind regards
Stefan
sum(Sales) / sum(total <Year> Sales)
sum(Sales) / sum(total <Year> Sales)
Thanks Steve!