Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exist a formula difference between QlikView version 10 and 11?

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

0 Replies