Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Luminary
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...

Many thanks for your comments.

Best regards

Carolin

1 Solution

Accepted Solutions
Luminary
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...

View solution in original post

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

View solution in original post

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