Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi! I have a problem i've been trying to find a solution on.
To get the weight/percentage of certain products, I need to get the total of units in each record, in order to obtain the percentage.
With the function TOTAL:
Sum ({<[Products]={Screws,'Cables','Hammers’,’Nails’}>} TOTAL units)
The problem is that Qlik shows the total amount of units for all months.
Could you help me, please?
Using the TOTAL qualifier will TOTAL ignoring all dimensions. You can use Total <Field> if you'd like to total within a context instead, e.g. Sum ({<[Products]={Screws,'Cables','Hammers’,’Nails’}>} TOTAL <Month> units)
Using the TOTAL qualifier will TOTAL ignoring all dimensions. You can use Total <Field> if you'd like to total within a context instead, e.g. Sum ({<[Products]={Screws,'Cables','Hammers’,’Nails’}>} TOTAL <Month> units)
It works. Thank you!!!
I just discover that also works with aggr(nodistinct Sum..., but I think your method is better.