Filter

[smilingjohn]

Emergency need help

in my application there a field by name "Brand"  in which there are two values 'L and M ', and by defualt there is a triger being set which selects L and it turns into green.

In a bar chart i have a expression and  the values will appear only when the M and L gets deselected  as shown in the below snap.

Is there any way that i use this functionality in the expression ? so the values should apeear. even i dont manaully deselct this L

or is there any way that if i create a clear option for the Brand Field then this should not impact all other triggers which are designed in a way to select the Brand 'L' ?

[m_woolf]

Use set analysis with Brand =. If you share your expression, I can be more specific.

[smilingjohn]

HI mw

This is the expression iam using .

Sum

(

  {

    <

    Date= {">=$(Dashboard_StartDate)<=$(Dashboard_EndDate)"},

    Hierarchy = P(Hierarchy_S),

    Brand=

    >

  } If(Cust_Zip=Replace(ValueList($(=Dashboard_Leads_LeadRankings_ZipList_Desc),'',$(=Dashboard_Leads_LeadRankings_ZipList_Asc)), Chr(11), ''), Count)

)

There are some Trigers being set which will by default  display only L under the brand field as shown in the screen shot.

becuase of which the bar chart is showing 0 value... is there any way that the Brand field gets deslected within the expression ? and execut it ?