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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.