Solved: How can I "Group" datas in Pivot table - Qlik Community

Report Inappropriate Content · ‎2011-03-11

I just want summarize weights in this pivot table. rdate is a dimension, sum(weiht) is an expression

Anonymous · ‎2011-03-11

I assume that you want to see rdate 10.03.2011 only once.
If it is a dimension in your table, it is most likely that you have it in a timestamp format (that is with hours, minutes,..) so they are all in fact different although presented as a date. You need it in the date format, preferably in the script:
date(floor(rdate)) as rdate

View solution in original post

john_duffy · ‎2011-03-11

You can select 'Show Partial Sums' in the charts Presentation tab to summarize Weights at various levels.

Is this what you are trying to accomplish?

Anonymous · ‎2011-03-11

I assume that you want to see rdate 10.03.2011 only once.
If it is a dimension in your table, it is most likely that you have it in a timestamp format (that is with hours, minutes,..) so they are all in fact different although presented as a date. You need it in the date format, preferably in the script:
date(floor(rdate)) as rdate