Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Professor-Ambassador
Professor-Ambassador

IF Statement - Date

Hi - I am creating a column a pivot table visualization for a dimension.

I am using the following expression and the IF statement is not working (always going to FALSE).

=IF([skdate.autoCalendar.Year]=2021,skid,null())

 

Any thoughts ? Jerry

1 Solution

Accepted Solutions
edwin
Specialist III
Specialist III

you may need to supply sample data.  

however, if what you want is evaluate your table only for year=2021, maybe the condition should be in your expression as set analysis instead of dimension.  and it will be faster

View solution in original post

1 Reply
edwin
Specialist III
Specialist III

you may need to supply sample data.  

however, if what you want is evaluate your table only for year=2021, maybe the condition should be in your expression as set analysis instead of dimension.  and it will be faster

View solution in original post