topic Re: Margin Calculation by Country in QlikView

Margin Calculation by Country

Mon, 06 Jul 2015 18:29:41 GMT

Hello Friends,

Can someone help me to fix this issue...

I need individual their own values for each country...Please look below image for clear understanding...

Thanks

venky

m_woolf — Mon, 06 Jul 2015 18:40:14 GMT

Your calculations are being done in variables, not in the chart expression; therefore they are not being aggregated by the dimension automatically.

You need to change your vMaxNet and vMaxCost variables (and who knows how many others).

vMaxNet would be somthing like:

aggr(Sum({<Year={$(vMaxYear)}>} UnitPrice * Quantity *(1-Discount)),Country)

when the NewGroup selected field is Country.

You can probably replace Country in the expression above with GetCurrentField("New Group")

MK_QSL — Mon, 06 Jul 2015 19:26:52 GMT

I can see that the variable declaration is wrong. For Example

vMaxMargin

SUM({<Year = {'$(vMaxYear)'}>}Quantity * UnitPrice * (1-Discount)) - SUM({<Year = {'$(vMaxYear)'}>}Quantity * UnitCost)

vMaxCost

SUM({<Year = {'$(vMaxYear)'}>}Quantity * UnitCost)

vMaxNet

SUM({<Year = {'$(vMaxYear)'}>}Quantity * UnitPrice * (1-Discount))

Similarly use below for previous year.

SUM({<Year = {'$(vPreYear)'}>}Quantity * UnitPrice * (1-Discount)) - SUM({<Year = {'$(vPreYear)'}>}Quantity * UnitCost)

I can't go each and every variables, so better to implement above suggested variables first and try to implement other accordingly..

Mon, 06 Jul 2015 20:39:29 GMT

Why cant i call "New Group" in set analysis...!!

crusader_ — Tue, 07 Jul 2015 08:28:22 GMT

Hi venkat,

You got the same result for Margin because those variables declares with "=" (equal sign).

Remove it from variable declaration and check attached result.

Hope this helps you.

Regards,

Andrei Kaliahin

m_woolf — Tue, 07 Jul 2015 14:48:05 GMT