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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-12-24 07:57 AM

Need help with where in expression and then avg number

Hi

I'm new to QV and i want to show the figure in a textbox and have the code in the expression if possible. Ward is a seperate column with column names and number of days is a column which displays figures.  I want my text box to show, only add ward 1 and ward 2 and give me the average of the number of days.

=if(ward = 'ward1' and 'ward2)avg (Number of days)

Many thanks in advance.

261 Views
0 Likes
0 Replies