Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Honored Contributor

Re: How to get date in expression label

Hi,

May be code in Label

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

devarasu07
Honored Contributor II

Re: How to get date in expression label

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

Re: How to get date in expression label

Thanks Devarasu

Community Browser