Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would to ignore some selection for some indicators.
Attached is a QVF example.
For example, the indicator "nb subscriptions" should:
- change according to selection in Calendar, DimOffers, and DimCustomers
- not change according to selection in DimCalls and DimAdvisors
I observe that:
- Sum({<call_reason=,advisor_name=>}nb_subscriptions) : ok
- Sum({<date={"$(=Max(date))"},call_reason=,advisor_name=>}nb_subscriptions): ko -> = 0 when selecting a value in call_reason or advisor_name fields
- Sum({<offer_name={'offerA'},call_reason=,advisor_name=>}nb_subscriptions): ok -> ignore selection in call_reason or advisor_name fields
- Sum({<date={"$(=Max(date))"},offer_name=,customer_name>}nb_subscriptions): ok -> ignore selection in offer_name or customer_name fields
So it seems that there is a problem when I associate, in a set analysis, "date={"$(=Max(date))"}" and some "fields=" expression, where fields were not used to calculate the indicator
Can someone help me please?
Thanks!
PFA.
Sum({<date={"$(=Max({<call_reason=,advisor_name=>}date))"},call_reason=,advisor_name=>}nb_subscriptions)
PFA.
Sum({<date={"$(=Max({<call_reason=,advisor_name=>}date))"},call_reason=,advisor_name=>}nb_subscriptions)
perfect! thank you...