Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot totals when no selections

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.

1 Solution

Accepted Solutions
MayilVahanan

HI

Can you use simply

= Sum(Session_Start_Count)

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

HI

Can you use simply

= Sum(Session_Start_Count)

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

Good point

Same with the line chart above...

Anonymous
Not applicable
Author

Thanks it is working..

Thought of grouping aggregating count at dimension level.


Anonymous
Not applicable
Author

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