topic Re: Display different date format in current selection in QlikView

Display different date format in current selection

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

Hi Guys,

Is it possible that if a user selects date range in the 'Input box'-'Select Date Range' the date that will be display in the 'current selection'

will be in the format 'YYYY-MM-DD HH:SS' instead of the format 'num'

I'm using the flowing variables:

VstartDate

VEndDate

VstartDate1=num(VstartDate)

VEndDate=num(VEndDate)

When the user selects a date range,I used variable event trigger on select in field:

='>=' & VstartDate1 & '<=' & VEndDate1

I've included a sample file

Thanks,

Re: Display different date format in current selection

Anil_Babu_Samineni — Wed, 25 Oct 2017 11:10:44 GMT

May be assign trigger like this?

='>='&Date(MonthsStart(1,Today()),'YYYY-MM-DD HH:SS')

Re: Display different date format in current selection

Clever_Anjos — Wed, 25 Oct 2017 11:10:46 GMT

Please change yours triggers to format your search

='>=' & Date(VstartDate1,'YYYY-MM-DD HH:SS') & '<=' & Date(VEndDate1,'YYYY-MM-DD HH:SS')

Re: Display different date format in current selection

ttal7878 — Wed, 25 Oct 2017 11:56:43 GMT

Thank cleveranjos‌ loveisfail‌

This is not exactly correct, since in my real model the field on which the trigger is triggered is in a format num.

Attached is a new example

Re: Display different date format in current selection

Anil_Babu_Samineni — Wed, 25 Oct 2017 12:36:46 GMT

So, That is the reason only we are providing Date() format instead Num(). You are not expecting this.

Re: Display different date format in current selection

ttal7878 — Wed, 25 Oct 2017 12:39:15 GMT

Not really understand

Re: Display different date format in current selection

Anil_Babu_Samineni — Wed, 25 Oct 2017 12:43:48 GMT

Will you able to explain exactly your needed, So then we can discuss

Re: Display different date format in current selection

ttal7878 — Wed, 25 Oct 2017 12:50:41 GMT

When the user selects a date in the 'Date range input box', I want the date displayed in the current selection to be like this:

saledate>='YYYY-MM-SS HH:MM'<='YYYY-MM-DD HH:MM'

Re: Display different date format in current selection

Anil_Babu_Samineni — Wed, 25 Oct 2017 12:57:58 GMT

Correct me, If i am wrong reading the read. Perhaps this?

='>=' & Date(VstartDate,'YYYY-MM-DD HH:SS') & '<=' & Date(VEndDate,'YYYY-MM-DD HH:SS')

Re: Display different date format in current selection

ttal7878 — Wed, 25 Oct 2017 13:03:34 GMT

It does not work, you can not select any date range at all

Re: Display different date format in current selection

Anil_Babu_Samineni — Wed, 25 Oct 2017 13:05:24 GMT

There is only 2 input boxes. Can you try selection from your end and then will look in detail. I believe this should work as expected.

Re: Display different date format in current selection

ttal7878 — Wed, 25 Oct 2017 13:08:35 GMT

What do you mean by selection from your end ?

I'am talking on the input 'Select Date Range'

Re: Display different date format in current selection

Anil_Babu_Samineni — Wed, 25 Oct 2017 13:12:47 GMT

Are you going to select in input box only, right? That is what my intention do selection and/or enter manually to check whether it is working or not in selection.

If you need from calendar object then go and change ..

Re: Display different date format in current selection

Clever_Anjos — Wed, 25 Oct 2017 13:41:54 GMT

Please find attached

Re: Display different date format in current selection

ttal7878 — Thu, 26 Oct 2017 06:25:54 GMT

I updated my example qvw.

I changed the field (SaleDate) to 'SaleDatenum'

When a user selects a date range, I want it to display in the current selection like this:

Is it possible to change the information shown in the current selection box?

Re: Display different date format in current selection

Clever_Anjos — Thu, 26 Oct 2017 09:37:05 GMT

It´s not possible,

If you select into SaleDatenum field, this field would be shown not SalesDate