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

Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!
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.