Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this ?
= sum(Aggr(Sum(FlagEdgeCase), MONTH,Categories))
Hi,
I am still getting the value as zero for all rows in that column (Flag total). Please check the screenshot below:
I
Can you share your app with some expected output. I am little unclear sorry.
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