Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
francois_974
Contributor III
Contributor III

complexe aggr expression

Hello all

i've a issue and i can't fid the solution myself . thanks for helping.

I load data contain the fuel statement by date of my véhicle like this 

affectation,vehicle registration, date, kilometrage, amount, volume  

i made a table like below to calculate the différence (Ecart) in km like that (firstsortedvalue (Kilométrage, -Date2)-firstsortedvalue (Kilométrage, Date2)

i would like to aggregate the Ecart for a special dimension but i can achieve this . (sum of the "Ecart" by "affectation")

for example i would find  

EST  = 153 344 km 

OUEST = 58 258 km 

can someone help me please 

francois_974_0-1633076256986.png

 

2 Replies
abhijitnalekar
Specialist II
Specialist II

Hi @francois_974 ,

Can you please share the sample dataset

Regards,
Abhijit
keep Qliking...
francois_974
Contributor III
Contributor III
Author

Hello

thanks for your reply

the data file join here . it's a fuel statement that i encrease monthly . 

i've got few pb because we change the fuel provider thats why i use the "date2" instead of "date de transaction" 

 do not hesitate ti join me if it wasen't clear

Francois