Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
tomtastic
Contributor II
Contributor II

Where cause in expression

Hi,

My current "working" expression: Avg([C_PR release time])

I however want to limit the chart to only show data for year 2016 so I tried the following expression:
Avg([C_PR release time]),[Year] ={'2016'}

Unfortunately I'm getting a message that there is an error in the expression.

1 Solution

Accepted Solutions
ali_hijazi
Partner - Master
Partner - Master

this is the correct syntax:

Avg({<Year={2016}>} [C_PR release time])


you need to read on Set analysis topic

I can walk on water when it freezes

View solution in original post

2 Replies
ali_hijazi
Partner - Master
Partner - Master

this is the correct syntax:

Avg({<Year={2016}>} [C_PR release time])


you need to read on Set analysis topic

I can walk on water when it freezes
tomtastic
Contributor II
Contributor II
Author

Thx Ali. That's exactly what I was looking for.