Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ttal7878
Creator
Creator

Display different date format in current selection

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,


15 Replies
Anil_Babu_Samineni

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.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ttal7878
Creator
Creator
Author

What do you mean by selection from your end ?

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

Anil_Babu_Samineni

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 ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Clever_Anjos
Employee
Employee

Please find attached

Capturar.PNG

ttal7878
Creator
Creator
Author

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?

Capture.JPG

Clever_Anjos
Employee
Employee

It´s not possible,

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