Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

Set Analysis Help

I have a main sheet with a bunch of metrics that I only want to change when the filter AEName is chosen.  All other filters should be ignored.

This is how I coded one of the expressions. 

Sum({1<Metric_Name={'Armored'},GoalMonth={"<=$(vCurrMonth)"},AEName=P(AEName)>}Target)

It works perfectly when I select an AEName.  All other filters are ignored. 

The problem I am having is when no AEName is selected (all data).  When I click on other filters the values do change and I don't want this to happen.

I am not sure what I need to add or change in my expressions to make sure that AEName is the only filter that ever changes the values.

1 Solution

Accepted Solutions

Re: Set Analysis Help

Try

Sum(

     {

          1<Metric_Name={'Armored'},

               GoalMonth={"<=$(vCurrMonth)"},

               AEName=$::AEName

   >}Target)

2 Replies

Re: Set Analysis Help

Try

Sum(

     {

          1<Metric_Name={'Armored'},

               GoalMonth={"<=$(vCurrMonth)"},

               AEName=$::AEName

   >}Target)

agigliotti
Honored Contributor II

Re: Set Analysis Help

let's try using the below expression:

Sum({1<Metric_Name={'Armored'},GoalMonth={"<=$(vCurrMonth)"},AEName=$::AEName >}Target)

Community Browser