Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Exclude the Filter

Hi,

I have two filters category and subcategory. When i select from category it will affect to the charts if select subcategory it never affect the charts. i need to use for the below expressions.

Chart 1  Expression :

sum((aggr(sum(spendUSD) / aggr(nodistinct sum(spendUSD),CATEGORY) * speedToSavings,

CATEGORY, SUBCATEGORY))

Chart 2 Expression :

lever

Thanks in advance.

Regards,

Subash.

1 Solution

Accepted Solutions
Not applicable

Re: Exclude the Filter

Thanks Sunny, I got it.

Sum({<SUBCATEGORY>} (Aggr(Sum({<SUBCATEGORY>} spendUSD) / Only({<SUBCATEGORY>}

Aggr(NODISTINCT Sum({<SUBCATEGORY>} spendUSD), CATEGORY)) * Only({<SUBCATEGORY>} speedToSavings),

CATEGORY, SUBCATEGORY)))

Thanks alot.

-- Subash.

7 Replies

Re: Exclude the Filter

So selection in category should change the expression's output, but selection in subcategory should not impact? Is your expression even working today?

Not applicable

Re: Exclude the Filter

Thanks for the response Sunny.

Selection in subcategory is affecting the expression that is my problem. I don't want to affect the expression if i select subcategory.

--Subash.

Re: Exclude the Filter

May be try this:

Sum({<SUBCATEGORY>} (Aggr(Sum({<SUBCATEGORY>} spendUSD) / Only({<SUBCATEGORY>} Aggr(NODISTINCT Sum({<SUBCATEGORY>} spendUSD), CATEGORY) * Only({<SUBCATEGORY>} speedToSavings),

CATEGORY, SUBCATEGORY))

Not applicable

Re: Exclude the Filter

Thanks Sunny but showing ')' error. Since i m very new to this so i can not predict this.

Also do you have any idea for this below

lever - this the field which displays the text content. we also need to restrict the subcategory level


-- subash

Highlighted

Re: Exclude the Filter

Try this:

Sum({<SUBCATEGORY>} (Aggr(Sum({<SUBCATEGORY>} spendUSD) / Only({<SUBCATEGORY>} Aggr(NODISTINCT Sum({<SUBCATEGORY>} spendUSD), CATEGORY)) * Only({<SUBCATEGORY>} speedToSavings),

CATEGORY, SUBCATEGORY))

Not applicable

Re: Exclude the Filter

Thanks Sunny, I got it.

Sum({<SUBCATEGORY>} (Aggr(Sum({<SUBCATEGORY>} spendUSD) / Only({<SUBCATEGORY>}

Aggr(NODISTINCT Sum({<SUBCATEGORY>} spendUSD), CATEGORY)) * Only({<SUBCATEGORY>} speedToSavings),

CATEGORY, SUBCATEGORY)))

Thanks alot.

-- Subash.

Re: Exclude the Filter

Glad you did, Please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Community Browser