Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to calculate margin in listbox. I mean, on below listbox, first red line's value(Brüt Kar Marjı %) must be BRÜT KAR / Satış Gelirleri (175.421/1.131.781) .
Likewise, second red line's value must be 'FAALİYET KARI / Satış Gelirleri' (58.237 / 1.131.781)
Likewise, last red line's value (EBITDA KarMarjı %) must be 'EBITDA(FAVÖK) / Satış Gelirleri'(194.952 / 1.131.781)
'B' is an expression that sum(Budget)
Could you please help me.
Thank you.
Fatih Tomruk.
This should ideally be done in the script. Check this blogs : How IntervalMatch Solved My Profit and Loss Dilemmaand How to Create a Profit and Loss Statement in QlikView
Thank Tresesco. But This can't solve my problem.
I need a formula like this;
if(=2,sum({<B={'2'}>} C) / sum({<B={'3'}>} C) , sum(C))
But it doesn't work now. Can anyone help?
But This can't solve my problem.
I could not really understand why this can't.. (not sure if missing something). Check a small sample how you can probably proceed.
Screen shot is not useful for helpers. Would you share excel
My values is not 1, 2, 3 and 4 but 'Brüt Kar' , 'Satış Gelirleri'.
And the other, first margin must be Brut Kar / Satış Gelirleri but second must be 'Faaliyet Karı / Satış Gelirleri'