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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?