Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jleberre
New Contributor

Unable to ignore some selection in a star model

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!

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Unable to ignore some selection in a star model

PFA.

Sum({<date={"$(=Max({<call_reason=,advisor_name=>}date))"},call_reason=,advisor_name=>}nb_subscriptions)

2 Replies
shraddha_g
Honored Contributor III

Re: Unable to ignore some selection in a star model

PFA.

Sum({<date={"$(=Max({<call_reason=,advisor_name=>}date))"},call_reason=,advisor_name=>}nb_subscriptions)

jleberre
New Contributor

Re: Unable to ignore some selection in a star model

perfect! thank you...