Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

how to convert Num to text in for date ,i want to display in string for month.

how to convert Num to text in for date ,i want to display in string for month.

=(max(month(dvdate))-1)

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: how to convert Num to text in for date ,i want to display in string for month.

Hi,

try with this expression

=Date(Date#((max(month(dvdate))-1),'M'),'MMM')

or 

=Date(Date#((max(month(dvdate))-1),'M'),'MMMM')

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: how to convert Num to text in for date ,i want to display in string for month.

Hi,

try with this expression

=Date(Date#((max(month(dvdate))-1),'M'),'MMM')

or 

=Date(Date#((max(month(dvdate))-1),'M'),'MMMM')

View solution in original post