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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
dcd123456
Creator
Creator

error un calc avg in graph

hello

i have a table with 3 fields Month, date1 and date2. I need to show a bar chart  agregated by month that show the avg of days between two date fields.

In dimension i define the field month, in expresion i put the next expresion:

num(avg(H_MFECHA-H_MFECHA2),'####,##',',','.')

the result of the avg in the bar chart are wrong.

somebody know what is wrong??

10 Replies
dcd123456
Creator
Creator
Author

it works ok

thanks

regards

diego