Discussion Board for collaboration related to QlikView App Development.
I have Year and Month fields in QlikView and I need YearMonth beside each other like:
How can I do it?
Date(MakeDate(Year, Month, 1), 'YYYYMM') as YearMonth
Date#(Year&Month, 'YYYYMM') as YearMonth
Date(MakeDate(YEAR, MONTH), 'YYYYMM') as YearMonth
Try this in backend:
Year(Datefield) & ' ' & Month(Datefield) as YearMonth
Create Field in script
date#(Year &Month,'YYYYMM') as YearMonth
concat fields in edit script to get result
Year&Month as YearMonth
concat fields as a calculated dimension to use in any Qlikview object
or also use same in list box defining custom expression.