Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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.

View solution in original post

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

Not applicable
Author

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))

Not applicable
Author

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))

Not applicable
Author

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