Total sum of a metric on Calculated dimension

[#1]

Hi,

I started working on Qlikview a week back and I am working on this dashboard.

I have a particular requirement which I am not able to achieve:

So, I have a calculated dimension "Categories" added in my script which based on certain conditions tags each name as SLEEPERS,STARS,WEAKLINKS etc.

Now, I have flagged the names based on certain condition which works fine.

The issue is, I want the sum of those flags on the level of calculated dimension CATEGORIES(SLEEPERS, STARS..etc) and my month field.

I am not able to achieve it because, the flag itself is a calculated field so sum of calculated field doesn't work. I tried using aggr, function but it returns zero for all rows. I am not sure why. in the aggr function I use the sum(Aggr(Flag,MONTH,Categories))

Can someone suggest a work around for this? I have attached the screenshot of the report for better understanding of the requirement

[vishsaggi]

Try this ?

= sum(Aggr(Sum(FlagEdgeCase), MONTH,Categories))

[#3]

Hi,

I am still getting the value as zero for all rows in that column (Flag total). Please check the screenshot below:

I

[vishsaggi]

Can you share your app with some expected output. I am little unclear sorry.

[#5]

Hi,

Please find the attachment.

If the flag metric is unclear: it gives an output as 1 if Fractile<Eulddistance1.

Euclddistance1 is in the script.

Regards,

Anwesha