Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Calculating total in dimension

I am attempting to use this calculation in my dimension but it is not working:

if(sum(total <PROD_DT, REL_CD> VALUE) > 10000000, REL_CD))

What I m trying to do is calculate a sum of 'VALUE' for each 'REL_CD' on a given 'PROD_DT' and only display that 'REL_CD' in the dimension if it's sum is greater than 10 million. Does anyone know why this is not working and if there is a way to successfully accomplish what I need?

Thank you

1 Solution

Accepted Solutions

Re: Calculating total in dimension

Try this:

=If(Aggr(Sum(TOTAL <PROD_DT, REL_CD> VALUE), REL_CD) > 10000000, REL_CD))

1 Reply

Re: Calculating total in dimension

Try this:

=If(Aggr(Sum(TOTAL <PROD_DT, REL_CD> VALUE), REL_CD) > 10000000, REL_CD))

Community Browser