topic Re: Case expression: with date values in QlikView

Case expression: with date values

TheMdu — Tue, 12 Feb 2019 12:09:06 GMT

Hello,

How do I use apply this case expression when loading a .qvd?

Code works perfectly if my data source is SQL.

Looked at various examples posted on this forum, but could'nt find anything that deals with a date range?

"Select *,

case

when ImportDate between '2017-12-01 00:00:01' and '2017-12-31 23:59:00' then '2017/12'
when ImportDate between '2018-01-01 00:00:01' and '2018-01-31 23:59:00' then '2018/01'
when ImportDate between '2018-02-01 00:00:01' and '2018-02-28 23:59:00' then '2018/02'
when ImportDate between ' 2018-03-01 00:00:01' and '2018-03-31 23:59:00' then '2018/03''
end as ConversionMonth

from tblsales"

Thanks

Re: Case expression: with date values

gn_marvs1989 — Tue, 12 Feb 2019 13:26:23 GMT

For this kind of ranges. The IntervalMatch() could be handy.
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/IntervalMatch.htm

Re: Case expression: with date values

Marcos_rv — Tue, 12 Feb 2019 13:31:20 GMT

Hi how are you??
mmmmm it does not serve you directly to use the date to remove the year / month ??
try this:
(Preceding Load)
load *,
year (ImportDate) & '/' & num (month (ImportDate), '00') as ConversionMonth;

sql select *
from resident tblsales;

Regards!!!