I am trying to only sum dates for a gauge chart that are for the year 2018, the column of data has data from 2016 to 2018. The data format is 04/03/2018 00:00:00. Do I need to reformat the data or can Qlik view identify the year and use that in the sum expression.
Depends on your timestamp format value.
SET TimestampFormat='MM/DD/YYYY HH:mm:ss';
This would match the value supplied, then you would use Year(datefield) = 2018, if for a Set Expression, you would either need to have date connected to a Master Calendar (highly) recommended so you could do:
without you need a more complex expression against a primarykey field:
I have tried the above responses. Essentially I am looking to use a KPI visualization to display the amount of material collected in 2018. When I use the set timestamp comment in the KPI data element it says an error, does the set timestamp need to be put elsewhere on Qlik sense desktop