Exclude the Filter

[#1]

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.

[sunny_talwar]

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

[#3]

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.

[sunny_talwar]

May be try this:

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

CATEGORY, SUBCATEGORY))

[#5]

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

[sunny_talwar]

Try this:

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

CATEGORY, SUBCATEGORY))

[#7 · Accepted solution]

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.

[sunny_talwar]

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny