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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get date in expression label

Hi,

I have a calendar object in dashboard that i use to select date (in 'M/D/YYYY' format) and pass on the data value to a variable 'vBaseFrom'.

Now i have a table where i want to show this value as label for an expression. I used following code in Label,

='Sample% '& Date($(vBaseFrom),'M/D/YYY')

However i am getting following result not matter what i choose,

Sample% 12/30/1899

I am using this variable for set analysis & it's giving right result. Which means it has got the value & i can see it variable overview window.

Can anyone help please.

3 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

May be code in Label

= 'Sample% '& Date ($ (vBaseFrom),' M / D / YYYY')

devarasu07
Master II
Master II

Hi,

It's limitation with our current version. you can use below extension

https://github.com/ralfbecher/irregular-widgets

http://qliksite.io/tutorials/qliksense-widgets-tutorial/recipes/table-with-dynamic-label/

Hope this helps to you

Not applicable
Author

Thanks Devarasu