Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
VaishnaviMogal11
Partner - Contributor III
Partner - Contributor III

Not able to aggregate by datetime field

Hi ,

I am using expression  as, 

=Aggr(if(trim(vin)=Trim(Only({[Map_view]} hash_vin)) AND
kbev_charge_session=Only({[Map_view]} charge_session),Timestamp(datetime)),datetime)

it is giving value as - only.  the values in datetime as eg. 

VaishnaviMogal11_0-1739106412314.png

if i am using same expression in measure without aggregation then it works, but i want to use it as dimension in line chart. how can i do this?

Thank you!

Labels (2)
1 Reply
MK_QSL
MVP
MVP

Add VIN and kbev_charge_session also in Aggr.