topic Re: Graph shows different values when select a single day in QlikView

Graph shows different values when select a single day

Wed, 12 Aug 2015 15:59:53 GMT

Hi All,

I don't know why my graph behaves the way it is and I hope that you can help me.

Below is my expression:

(Sum(total aggr( if(((Sum (met_sl))/(count(session_id)))>.8, 1,0),half_hr_bucket)))/48

And these are the results for each day from above expression when I select every single day from the selection.

I don't know why it does not show above results on graph, instead it shows 58% for all days.

Your inputs are very much appreciated!

Thank you.

parthakk — Thu, 13 Aug 2015 05:34:03 GMT

Hi Liam,

Can u attach qvw file?

Regards,

Partha Kulkarni

sunny_talwar — Thu, 13 Aug 2015 05:35:41 GMT

Try this and see if the result changes:

=(Sum(TOTAL <Date> Aggr(If(((Sum(met_sl))/(Count(session_id)))>.8, 1, 0), half_hr_bucket)))/48

Kushal_Chawda — Thu, 13 Aug 2015 05:45:01 GMT

Can you share the sample app?

jonathandienst — Thu, 13 Aug 2015 05:50:18 GMT

You need the Date field in the Aggr() as it is the chart dimension, and I don't think you need the Total (hard to say without a sample):

=Sum(Aggr(If(Sum(met_sl)/Count(session_id) > 0.8, 1, 0), half_hr_bucket, Date)) / 48

=Sum(TOTAL Aggr(If(Sum(met_sl)/Count(session_id) > 0.8, 1, 0), half_hr_bucket, Date)) / 48

Thu, 13 Aug 2015 15:00:44 GMT

@Jonathan Dienst: your first expression works! I do not know why the Total is the problem, would you please explain? Thank you.

@All: Thank you very much for your inputs