topic Re: Margin calculation in listbox in QlikView

Margin calculation in listbox

fatihtomruk — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Margin calculation in listbox

tresB — Tue, 28 Mar 2017 05:02:12 GMT

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

Re: Margin calculation in listbox

fatihtomruk — Tue, 28 Mar 2017 06:39:37 GMT

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?

Re: Margin calculation in listbox

tresB — Tue, 28 Mar 2017 07:02:15 GMT

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.

Re: Margin calculation in listbox

Anil_Babu_Samineni — Tue, 28 Mar 2017 07:06:38 GMT

Screen shot is not useful for helpers. Would you share excel

Re: Margin calculation in listbox

fatihtomruk — Tue, 28 Mar 2017 07:53:37 GMT

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'