Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ericheleine
Contributor III
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

  

BankInteraction per month
Bank115
Bank212
Bank35
Bank44
Bank50
Bank60
Bank70

 

BankCost
Bank110000
Bank210000
Bank3

10000

Bank410000
Bank510000
Bank610000
Bank7

10000

Total cost expected is 40000

thanks for your help

1 Solution

Accepted Solutions
sunny_talwar

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

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

View solution in original post

6 Replies
tresesco
MVP
MVP

Try something like:

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

sunny_talwar

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

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

ericheleine
Contributor III
Contributor III
Author

thank you Tresesco for your quick answer.

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

The set analysis doesn't work in this case

eric

tresesco
MVP
MVP

Then Sunny's suggestion below should work.

ericheleine
Contributor III
Contributor III
Author

thank sunny

works perfectly

regards

sunny_talwar

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

LOAD Bank,

    Month,

    Bank&Month as Key

    ....

FROM ....;

and then this

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