Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
MVP
MVP

Re: How to aggregate more rows in a straight table

What if you use calculated dimension instead of the the field? Try expression like:

Timestamp(Floor(TimeString_mm, 1/24/60), 'DD:MM:YYYY hh:mm')

View solution in original post

arnould_it
New Contributor III

Re: How to aggregate more rows in a straight table

I've provided to upload a sample app, just waiting for the approval.

Menawhile you can see below another screenshot.

The red squared rows have to be aggregated in just 1 row:

aggr_min_b.png

MVP
MVP

Re: How to aggregate more rows in a straight table

Have you tried the way as I suggested above using floor() ?

arnould_it
New Contributor III

Re: How to aggregate more rows in a straight table

Hi Tresesco,

I've tried and it seems working well, I'll apply it on the entire app and test all.

Thanks a lot

Alessandro