Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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