Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i am a date qvd in which i am having
[Week End] and [Month]
week end has only the weekends
Month Has only start of the month
i want to create a column as Period which has only two values in Month Or Week as in the below image
it has to be done in scripting level, where i had to use this in Multibox Resource Library
gwassenaarsana.ismailjaganswuehlQlikViewEducation Services Layout & Visualizations
Hi,
Try like this
Hi,
Try like this
LOAD
*
If(MonthStart(Date1) = Date1, 'Month', 'Week') AS Period
FROM DataSource;
Hope this helps you.
Regards,
jagan.