5 Replies Latest reply: Feb 20, 2017 5:12 AM by Senthil Kumar Chitsabesa RSS

    i have the following expression working fine in Qlikview but not in Qsense

    Senthil Kumar Chitsabesa

      LOAD

                  [YEAR]*10000000000 + CEIL([MONTH]/6)*100000000 + CEIL([MONTH]/3)*1000000 + [MONTH]* 10000 + [WEEK] * 100 + DAY(IF([MONTH] = 01 AND [WEEK] > 05, WEEKEND(MAKEDATE([YEAR], [MONTH])), IF([MONTH] = 12 AND [WEEK] = 01, MONTHEND(MAKEDATE([YEAR], [MONTH])), IF(WEEKEND(MAKEWEEKDATE([YEAR], [WEEK])) > MONTHEND(MAKEDATE([YEAR], [MONTH])), MONTHEND(MAKEDATE([YEAR], [MONTH])), WEEKEND(MAKEWEEKDATE([YEAR], [WEEK])))))) AS [PERIOD_DATE_ID]  

              FROM [$(vFileName)] (qvd)