conversion of week and Month to Period

[kanve_03]

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‌

gwassenaar‌sana.ismail‌jagan‌swuehl‌QlikView‌Education Services ‌‌Layout & Visualizations‌

[jagan]

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.