topic Re: Start Date and End Date Filter in QlikView

Start Date and End Date Filter

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

Hi Everyone, Could anyone please help me on this

I'm using mapping list for column mapping where actual column name is [First Posted] and i'm replacing it as [Activity Creation Date] currently i placed

Existing Column: date#([First Posted], 'DD-MMM-YYYY') Renamed Column: Activity Creation Date in mapping table

Now, have implemented Start and End date functionality for that column. Now the problem is start and end date functionality is working good but i'm seeing numbers instead of dates in current selection field.

I have written date#([First Posted], 'DD-MMM-YYYY'), in load script.

Dates are filtering but showing numbers in current selection field i want to show the dates instead in current selection.

Can anyone help me out.

Thanks in advance.

@tresB @sunny_talwar @swuehl @rubenmarin

Re: Start Date and End Date Filter

StarinieriG — Tue, 25 Aug 2020 09:13:43 GMT

have you tried with this expression date(date#([First Posted], 'DD-MMM-YYYY')) ?

Re: Start Date and End Date Filter

TheBeginner — Tue, 25 Aug 2020 09:20:20 GMT

Yeah if im using this expressing filtering is not working

Re: Start Date and End Date Filter

TheBeginner — Tue, 25 Aug 2020 09:21:30 GMT

Is anything i need to update in column mapping sheet?

Thanks in advance

Re: Start Date and End Date Filter

rubenmarin — Tue, 25 Aug 2020 09:38:11 GMT

Hi, sometimes I use two fields: one with date format using Date() as StarinieriG posted, and other as num to use as filter in expressions

Re: Start Date and End Date Filter

TheBeginner — Tue, 25 Aug 2020 09:41:33 GMT

Firstly, Thanks for replying @rubenmarin , Could you please tell in breif.

Thanks in advance

Re: Start Date and End Date Filter

rubenmarin — Tue, 25 Aug 2020 09:51:23 GMT

Hi @TheBeginner, note that dates are always numbers, but those numbers can be shown with date format.

I don't know why you say that it doesn't filters when using Date(), I supposed it's beacuse you have a filter wich is using number format when it's expecting a date format, but that's just a guess, I will need to look where are you using that "filter" and how is created.

Anyway, you can have 2 fields: one using Date#() and another using Date(Date#()) and use one or the other.

- date#([First Posted], 'DD-MMM-YYYY') as NumActivityCreationDate
- date(date#([First Posted], 'DD-MMM-YYYY')=) as [Activity Creation Date]

Another possibility is using Date() function in front-end to show the value as a date.

If you can upload a sample it will be easier to answer.

Re: Start Date and End Date Filter

rushikale0106 — Tue, 25 Aug 2020 09:54:51 GMT

Hi,

I guess the following expression might solve the problem.

date(num([First Posted]),'DD/MM/YYYY')

Let me know if it it solves the problem or not.

Regards,

Rushi

Re: Start Date and End Date Filter

TheBeginner — Tue, 25 Aug 2020 10:10:56 GMT

Hi @rushikale0106 its not working