Exist a formula difference between QlikView version 10 and 11?

Wed, 03 Sep 2014 15:50:28 GMT

Hi,

I created in the old QlikView version (10) an object as a textbox. In this textbox I included my own text in combination with the formula.

For example:

=' Revenue Ø 7 days ' & num(sum({<imp_type={'Kept'})({$<day={">$(=date(max(day)-7))<=$(=max(day))"}>}revenue_daily)

/count({$<day={">$(=date(Max(day)-7))<=$(=max(day))"}>} distinct day),'###.##0 $')

it means:

1) my own comment: Revenue avg last 7 days ==> =' Revenue Ø 7 days '

2) formatting in USD ==> & num( .............................., '###.##0 $')

3) sum of field selection only "imp_type=kept" ==> sum({<imp_type={'Kept'})

4) for the last 7 days ==> ({$<day={">$(=date(max(day)-7))<=$(=max(day))"}>}

5) sum of field "revenue_daily" ==> revenue_daily)

6) dividide 7 days ==> /count({$<day={">$(=date(Max(day)-7))<=$(=max(day))"}>} distinct day)

------->In QlikView version 10, the textbox incl. the formula works, but in QlikView version 11 I couldn`t get any data.

The matching diagram works for both versions.

I`m greatful to get some information or tips.

Thanks in advance,

Alexander

topic Exist a formula difference between QlikView version 10 and 11? in QlikView