topic Re: Exclude the Filter in Integration, Extension & APIs

Exclude the Filter

Tue, 18 Oct 2016 19:33:01 GMT

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.

Re: Exclude the Filter

sunny_talwar — Tue, 18 Oct 2016 19:57:05 GMT

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

Re: Exclude the Filter

Tue, 18 Oct 2016 20:01:16 GMT

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

sunny_talwar — Tue, 18 Oct 2016 20:10:53 GMT

May be try this:

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

CATEGORY, SUBCATEGORY))

Re: Exclude the Filter

Tue, 18 Oct 2016 20:17:36 GMT

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

Re: Exclude the Filter

sunny_talwar — Tue, 18 Oct 2016 20:33:15 GMT

Try this:

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

CATEGORY, SUBCATEGORY))

Re: Exclude the Filter

Wed, 19 Oct 2016 10:55:35 GMT

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

sunny_talwar — Wed, 19 Oct 2016 16:50:53 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny