Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Now I have an urgent question. Please help me.
There is a data source, picture 1
Type, material 1, material 2, amount, cost
Use Qlikview production of the effect of the picture 2, the first dimension, the total amount, cost, gross profit is also very simple, but according to the material 2 gross margin >=60%, and the total 60%> gross margin =>50% count and total amount and accounting
How to write a script to calculate the formula?
I think I need to use aggr, but it's always wrong.
Please help me!
Thank you very much for your help, my friend.
I follow your method, do a TYPE list box, separate import and local reports.
But I was curious, in the case of not split report, there is a way to achieve through your formula?
In the end, I wish you a happy christmas!
Sorry Wrong QVW have a look to the Formulas Tab.
Gilles
Thank you very much for your reply, because I did not fully understand your formula, so take a roundabout way, now understand, your reply is very useful to me!
Merry Christmas!