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
Did you mean:
Contributor III

## Problem with aggr() or only()

Hi every body,

My goal is to calculate the total cost only with bank where i have an interaction

I don't arrive to fix this issue with the function aggr

 Bank Interaction per month Bank1 15 Bank2 12 Bank3 5 Bank4 4 Bank5 0 Bank6 0 Bank7 0

 Bank Cost Bank1 10000 Bank2 10000 Bank3 10000 Bank4 10000 Bank5 10000 Bank6 10000 Bank7 10000

Total cost expected is 40000

1 Solution

Accepted Solutions
MVP

Or may be this if you don't have a pre-aggregated Interaction per month column

Sum({<Bank = {"=Count(Interaction) > 0"}>} Cost)

6 Replies
MVP

Try something like:

Sum( {<[Interaction per month]={'>0'}>} Cost)

MVP

Or may be this if you don't have a pre-aggregated Interaction per month column

Sum({<Bank = {"=Count(Interaction) > 0"}>} Cost)

Contributor III
Author

that doesn't work because Interaction per month is a formula:
=count(interaction)

The set analysis doesn't work in this case

eric

MVP

Then Sunny's suggestion below should work.

Contributor III
Author

thank sunny

works perfectly

regards

MVP

Do you have just Bank as dimension or do you have Bank and Month as dimension? If you just have Bank as dimension, then you can try this

Sum({<Bank = {"=Count(Interaction) > 0"}>} Cost)

If you have Bank and Month as dimension, then may be create a new field in the script like this

Month,

Bank&Month as Key

....

FROM ....;

and then this

Sum({<Key = {"=Count(Interaction) > 0"}>} Cost)

Community Browser