Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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