is it already a date or just a string?
if it`s only a string you need to include a field like this:
I will assume that you field is called DATE
Load (etc ... ),
LEFT( DATE,4) & '-Q'& CEIL( NUM( MONTH( date#(DATE, 'YYYY-MM-DD') )) /3) AS YearQuarter
from / resident (etc...)
If it`s already a date, it can be just:
year(DATE) & '-Q'& CEIL( NUM(MONTH(DATE))/3) AS YearQuarter
Hope it helps,
Hi, If i understood your question properly. Qlikview will always work as per you are execting, if you have proper association between the table.
Take for example you have date as folows 2002-04-03, 2005-12-19, 2010-10-09, if you create year out of it and selected 2002, it would always select 2002-04-03.
Hope i have understood your question, if not correct me by rephrasing your question.