# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for
Did you mean:
Luminary

## Set Analysis

Hi,

Could anybody help me to correct my variable:

vRevenueTotalMax = sum({\$<FYear = {\$(=Max(FYear))}, OrderPhase_Desc = {Revenue}>} NettAmount\$(vCurrency));

I would like to see the Revenue for the Maximum Year that I choose from a List box. But it´s not calculating anything.

It´s for sure something about brackets etc or similar...

Best regards

Carolin

1 Solution

Accepted Solutions
Luminary

Quotation didn´t seem to help. This is a formula that I use which is working:

= sum({\$<OrderPhase_Desc = {Revenue}>} NettAmount\$(vCurrency));

Now it should include the Max-Year Term...

20 Replies
Not applicable

Is NettAmount\$(vCurrency) supposed to read as NetAmount\$(vCurrency)?

Not applicable

sum({\$<FYear = {\$(=Max(FYear))}, OrderPhase_Desc = {'Revenue'}>} NettAmount\$(vCurrency));

Quotations around Revenue?

Luminary

Quotation didn´t seem to help. This is a formula that I use which is working:

= sum({\$<OrderPhase_Desc = {Revenue}>} NettAmount\$(vCurrency));

Now it should include the Max-Year Term...

Luminary

NetAmount\$(vCurrency) should be read as e.g. NetAmountEUR or NetAmountUSD

Not applicable

Try:

vRevenueTotalMax = sum({\$<FYear = {Max(FYear)}, OrderPhase_Desc = {Revenue}>} NettAmount\$(vCurrency))

Luminary

Unfortunately not: this is how it´s looking like:

sum({\$<FYear = {Max(FYear)}, OrderPhase_Desc = {Revenue}>} NettAmountUSD)

Not applicable

sum({<FYear={\$(=Max(FYear))},OrderPhase_Desc={'Revenue'}>}NettAmount\$(vCurrency))

Just checking its not the current selections

Partner

Try this,

vRevenueTotalMax = sum({\$<FYear = {"\$(=Max(FYear))"}, OrderPhase_Desc = {'Revenue'}>} NettAmount&\$(vCurrency));

Not applicable

sum({\$<FYear = {Max({\$}FYear)}, OrderPhase_Desc = {Revenue}>} NettAmountUSD) ?

I feel like FYear = {Max(FYear)} does not consider the current selection, so maybe the above will work.

Tags