topic Re: hard code the date in QlikView

hard code the date

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

Hi,

I need to hard code the date as

=if(storeID='017','07/19/2016',date(min(New_A7AIDT),'MM/DD/YYYY')) and it's working fine

But they have intiated two new stores and they want activated date on

storeID = 25,activated date =0 8/4/2016

storeID = 27 activated date = 08/5/2016

storeID = 26 activated date = 08/6/2016

How to integrate all these dates in one expression.

Thanks...

Re: hard code the date

sunny_talwar — Fri, 05 Aug 2016 14:15:16 GMT

May be like this:

Pick(Match(storeID, '017', '25', '27', '26') +1, Date(Min(New_A7AIDT),'MM/DD/YYYY'), '07/19/2016', '08/04/2016', '08/05/2016', '08/06/2016')

Re: hard code the date

nareshthavidishetty — Fri, 05 Aug 2016 14:30:20 GMT

Hi Sunny,

Small change we don't need the min

date but after using the above logic the date remains same.

Logic used: Pick(Match(A7AACD,'017','25','27','26')+1,Date((New_A7AIDT),'MM/DD/YYYY'),'07/19/2016','08/04/2016','08/05/2016','08/06/2016')

Thanks..

Re: hard code the date

sunny_talwar — Fri, 05 Aug 2016 14:32:28 GMT

Not really sure what you are trying to do, can you share a sample or some screenshots?

Re: hard code the date

nareshthavidishetty — Fri, 05 Aug 2016 18:47:38 GMT

Hi,

The below logic is working fine when i have tested with an sample data.

But it's not working in my chart.We have converted the century date(1160804) format into normal date format

where,

New_A7AIDT = date(date#(A7AIDT+19000000, 'YYYYMMDD'),'MM/DD/YYYY')

Logic:

Pick(Match(storeID, '017', '25', '27', '26') +1, Date(Min(New_A7AIDT),'MM/DD/YYYY'), '07/19/2016','08/04/2016', '08/05/2016', '08/06/2016')

Thanks..

Re: hard code the date

nareshthavidishetty — Sat, 06 Aug 2016 07:22:51 GMT

Hi Sunny,

Issue resolved...great..

My mistake..I need to change location detail instead of '25' need to change '025'.

Thanks...