Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
mrjohn23
Contributor III

Count in Expression using an AltState

Can someone help with an expression. I have the below expression.I want to put a filter in the expression to only count when the year = 2016. Where Start_dt_yyyy = 2016

Count({[AltState1]} CLT_CLT_PGMID)

Tags (1)
1 Solution

Accepted Solutions

Re: Count in Expression using an AltState

May be this:

Count({[AltState1]<Start_dt_yyyy = {2016}>} CLT_CLT_PGMID)

View solution in original post

1 Reply

Re: Count in Expression using an AltState

May be this:

Count({[AltState1]<Start_dt_yyyy = {2016}>} CLT_CLT_PGMID)

View solution in original post