topic Picking updated date field from data in QlikView

Picking updated date field from data

venkat1 — Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

Please help me out from this logic,I am showing branch wise sales by taking Date-1 for calendar,Logic here i should apply here is If "Date-2" having "-" then i should take from Date-1 else i should consider a date from Date-2.

Branch Date-1 Date-2 Sales
A 14-06-2019 - 1600
B 15-09-2015 - 18000
C 12-04-2018 10-03-2017 3651
D 16-01-2015 - 648
E 02-05-2016 08-04-2017 5648

Re: Picking updated date field from data

Taoufiq_Zarra — Sat, 25 Jan 2020 22:32:52 GMT

if(len([Date-2])<2,[Date-1],[Date-2]) as New_Date2,

Re: Picking updated date field from data

Vegar — Sun, 26 Jan 2020 08:13:18 GMT

Is your empty - values actually the string "-" or is it just Qlikview that is presenting NULL values as -.

If they are NULL values then you can use the Alt() function

Alt([Date-2],[Date-1]) as Date

If its not null, but a string, then use the if solution suggested by @Taoufiq_Zarra .