Hi, there, I met an interesting issue when creating a simple Qlik Sense app. I added a table into the app and made it display all rows. Here is the load script.
LOAD date, charge, city, Date(datetime,'yyyy') as fiscal_year From [source table];
All data were displayed well. When I clicked 'New York', all rows associated with 'New York' (row #1 and #5) were high-lighted. The same thing happened if I selected a charge (such as $100). However, when I selected 2023 (fiscal_year), only the first row was high-lighted. Another 2023 row (row #2) was not. It looks like the fiscal_year field displays year, but it somehow still uses date field as its value. How to fix it?
Date(datetime,'yyyy') is not converting datetime into a year. It is only showing datetime with the 'year' format. So when you select one, you select the date which is behind ; not the year.
