topic Pivot totals when no selections in QlikView

Pivot totals when no selections

Anonymous — Thu, 07 Nov 2013 20:58:24 GMT

Hi All,

Can you please look on the below attached app and see whats the wrong with my expression for sessions.

When i select any Dashboard name or User i can able to see Totals in Session column and if there no selections it is not populating Session Column.

Anonymous — Thu, 07 Nov 2013 21:12:48 GMT

I think you need to add aggregation by DocName in the last part.

(If(Dimensionality() <= 1, Sum(Session_Start_Count),

If(Dimensionality() = 2,Aggr(Sum(Session_Start_Count),WeekEndDate),

Aggr(Sum(Session_Start_Count),WeekEndDate,Authenticated_User,DocName))))

MayilVahanan — Thu, 07 Nov 2013 21:13:01 GMT

Can you use simply

= Sum(Session_Start_Count)

can you please explain why you using aggr() in it

Anonymous — Thu, 07 Nov 2013 21:15:09 GMT

Good point

Same with the line chart above...

Anonymous — Thu, 07 Nov 2013 21:19:50 GMT

Thanks it is working..

Thought of grouping aggregating count at dimension level.

Anonymous — Thu, 07 Nov 2013 21:21:59 GMT

Expression in charts are aggregated by dimensions, this is how it works...