Discussion Board for collaboration on QlikView Layout & Visualizations.
What wrng in my expression
my date field as
=date(MonthsStart( "date"), 'YYYY-MMM')
i want to display date as :2014-may
how can i get this date.
Go to Solution.
You tried it with MonthsStart which requirred more than one parameter and therefore throws an error but you need instead MonthStart - to compare:
Details to their differences could you find within the help.
=date(MonthStart(date#(date, 'YYYY-MMM-DD')), 'YYYY-MMM')
Its shwng error in expression
thnx marcus.....even though it is nt gvng any value.. as expression is ok . MonthStart i used dis
I have tried this within a textbox and it's working fine:
=date(MonthStart(date#('2014-may-10', 'YYYY-MMM-DD')), 'YYYY-MMM')
Can you use the below command in the expression.
yeah.. its gvng correct now but....we are gvng the date manually ryt.......if my data chnges? how can i ?
replace with the '2014-may-10' with the field name, in the code below datefield
load * inline [
date(MonthStart(date#(datefield, 'YYYY-MMM-DD')), 'YYYY-MMM') as newdatefield
thnx maxgro........if i want to do in frnt end. how to do this? without creating new field in bakend?