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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating average

Hi,

I am using a set expression to calculate average age of contacts in a staight table (see attachment).

=num(avg({<Type ={'Epost', 'TelefonCRM'}, KontaktAlder={"*"}, KONTAKT_GYLDIG_TIL={">=$(=Max(%Dato))"}, KONTAKT_GYLDIG_FRA={"<=$(=Max(%Dato))"}>} KontaktAlder),'###').

Could anyone help explaining why the value in the table title (same value is shown in a text object) is different from the value in the "Expression total"?

3 Replies
sunny_talwar

Are you using an expression for your chart label?

Not applicable
Author

Well, yes it uses the expression as default.

sunny_talwar

Would it be possible to share a sample where you are seeing this issue?