Discussion Board for collaboration related to QlikView App Development.
I've got a dual Field Month.
I need to set an expression which returns a text value which corresponds to a particular numeric value.
Say, I've got number X.
I'd like to set a function which returns the text value of X.
Is it possible?
Thank you in advance,
Each value of the Field month in dual.
So if I set number 1 the expression shoul return 'January',
if I set number 2 the expression shoul return 'February' and so on.
Actually, I've got several dual fields.
one is Month, another is Media (each media has got its own text and numeric value).
Is it possible to solve the task for the Media field as well?
Create the Month using Date field
Date(YourDateField,'MMMM') as Month
Create the inline table to assign number
load * inline [