Margin Calculation by Country - Qlik Community

Report Inappropriate Content · ‎2015-07-06

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 · ‎2015-07-06

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 · ‎2015-07-06

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..

Report Inappropriate Content · ‎2015-07-06

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

crusader_ · ‎2015-07-07

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 · ‎2015-07-07