topic date format in textbox with set analysis in QlikView

date format in textbox with set analysis

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

HI experts,

I have a date 01/2016 .. now i want get the same date in textbox with set analysis expression how i can?

Thanks In advance

Re: date format in textbox with set analysis

sunny_talwar — Thu, 27 Oct 2016 09:34:00 GMT

date using set analysis, how are you getting this date everywhere else? Can you may be give a sample with what you are expecting to see?

Re: date format in textbox with set analysis

prabhas277 — Thu, 27 Oct 2016 09:37:11 GMT

if we write = "01/2016 in text box then we can see the 01/2016.

now i want get the same results by using set analysis expression in textbox

Re: date format in textbox with set analysis

sunny_talwar — Thu, 27 Oct 2016 09:39:22 GMT

Set analysis cannot help you in getting a date, may you want this?

Date(MakeDate(2016, 1), 'MM/YYYY')

Re: date format in textbox with set analysis

tresB — Thu, 27 Oct 2016 09:42:15 GMT

Not sure I understood right. May be like: = Only({<DateField={'01/2016'}>}DateField) . Now instead of fixing this date you can use a variable that would store user input or so, like: = Only({<DateField={'$(vDate)'}>}DateField)