Discussion Board for collaboration related to QlikView App Development.
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:
When the user selects a date range,I used variable event trigger on select in field:
='>=' & VstartDate1 & '<=' & VEndDate1
I've included a sample file
May be assign trigger like this?
Please change yours triggers to format your search
='>=' & Date(VstartDate1,'YYYY-MM-DD HH:SS') & '<=' & Date(VEndDate1,'YYYY-MM-DD HH:SS')
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
So, That is the reason only we are providing Date() format instead Num(). You are not expecting this.
Not really understand
Will you able to explain exactly your needed, So then we can discuss
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'
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')
It does not work, you can not select any date range at all