topic Filter in QlikView

Filter

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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' ?

Re: Filter

m_woolf — Thu, 09 Mar 2017 13:41:48 GMT

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

Re: Filter

smilingjohn — Thu, 09 Mar 2017 13:52:55 GMT

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 ?