Discussion Board for collaboration related to QlikView App Development.
I have Date fields as below.I want to make them as one field.I don't want to do cross table.Can I just do by using If statement ?
M2MYear FHYear SurYear PAYear
2019 2017 2015 2016
2018 2016 2012 2014
Tried below but doesn't work...any other method to do this please ?
if(wildmatch(M2MYear,'*' ) ,M2MYear,
if(wildmatch(FHYear ,'*') ,FHYear,
if(wildmatch(PAYear,'*') ,PAYear )))) as Year
From reading this formula, I think you are expecting to get the first non null value in this order. Is that correct?
I am expecting all Year as one column.
The Year list will have 2012,2014,2015,2016,2017,2018,2019
Along these lines? So if you you selected 2012 from year, it would select any data value from 2012:
I doubt you can do that using If statement. can you try below:
LOAD M2MYear as Year, * INLINE [
LOAD FHYear as Year
LOAD SurYear as Year
LOAD PAYear as Year
Drop Fields FHYear,SurYear,PAYear;
Thank you but that didnt work.Psee attacghed sample.When I select id 4012001 only one year gets selected instead it should select 2012,2015,2016.
sunnysunnystalwar1swuehl aNY THOUGHTS PLEASE ?
Yes because that is the only data you provided hence the solution for the same. I will look into your files and get back.
Try this in your script:
ReId as SpecialPrj_SavingsREIDKey,
year(mTMExpectedCompleteDate) as Year,
year(mTMExpectedCompleteDate) as mTMExpectedCompleteDate ,
year(pSOExpectedCompleteDate) as pSOExpectedCompleteDate,
year(SSExpectedCompleteDate) as SSExpectedCompleteDate,
year(FFExpectedCompleteDate) as FFExpectedCompleteDate
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
pSOExpectedCompleteDate as Year
SSExpectedCompleteDate as Year
FFExpectedCompleteDate as Year