topic Re: Dates in Variables but Formatting Issue In Textbox in QlikView

Dates in Variables but Formatting Issue In Textbox

Peter_Brunner — Tue, 14 Jun 2016 06:25:31 GMT

Hi All,

I have been trying several different ways to Display a Date which actually is in correct Format in a Variable

but when I try to display this in a text box I can not get it to format correctly?

see attachment

any Help appreciated and is there any quick reference sheet with formatting dates in script expressions, text boxes etc.;?

thanks Peter

Re: Dates in Variables but Formatting Issue In Textbox

swuehl — Tue, 14 Jun 2016 15:24:06 GMT

Peter, not sure what the issue is, I've created a text box and used

=vDateFromDisplay

and got back

13/06/16

Re: Dates in Variables but Formatting Issue In Textbox

sunny_talwar — Tue, 14 Jun 2016 15:24:28 GMT

Try this:

='From Date'&' ' &vDateFromDisplay&' '&'To Date ' &$(vDatesTo)&' '&'........I need this to show 13/06/16'

Re: Dates in Variables but Formatting Issue In Textbox

swuehl — Tue, 14 Jun 2016 15:32:06 GMT

The complete expression with from and to date then looks like

='From Date'&' ' & vDateFromDisplay &' '&'To Date ' & vDatetoDisplay

Reason why your version did not work:

After the dollar sign expansion the expression looks like

='From Date'&' ' & 13/06/16 &' '&'To Date ' & vDatetoDisplay

and 13 divided by 6 divided by 16 equals to 0,13541666666666666666666666666667

Re: Dates in Variables but Formatting Issue In Textbox

Peter_Brunner — Wed, 15 Jun 2016 06:21:17 GMT

Hi Stefan,

thanks for this

I was trying to using these formats

$(vDateFromDisplay) or ' $(vDateFromDisplay) ' but did not use vDateFromDisplay

also your explanation makes sense now why I was getting decimal value

It would be good to get these rules straight where to use what format e.g.: Script , Expression Textbox for variables

Thanks again

regards Peter

Re: Dates in Variables but Formatting Issue In Textbox

Peter_Brunner — Wed, 15 Jun 2016 06:41:03 GMT

Stefan,

I wish to mark your answer correct ...I always have trouble seeing this Correct answer button , all I see is the actions drop down and mark a Helpful !!

How do I navigate to this button correctly ?...currently my discussion is waiting for Moderation to accept my reply

does this have an effect on this button ...tried 2 browsers but I can not see it in either

I think a lot of other users have this very same issue!

thanks Peter

Re: Dates in Variables but Formatting Issue In Textbox

swuehl — Wed, 15 Jun 2016 08:29:06 GMT

You should be able to see the button when opening the full thread in the browers (not viewing from within the inbox)

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Dates in Variables but Formatting Issue In Textbox

Peter_Brunner — Wed, 15 Jun 2016 22:49:20 GMT

Hi Stefan,

I have read your link but No Go, I can not see button ..see below what i see this page has white back ground and I clicked by hit heading

Stefan please explain step by step how I get to this button ?

see below this is what I see this page has white back ground and I clicked by hit heading

this page I am looking at .....the address =.Dates in Variables but Formatting Issue In Textbox

Peter

Re: Dates in Variables but Formatting Issue In Textbox

swuehl — Wed, 15 Jun 2016 22:59:16 GMT

It seems like you haven't marked the discussion as question, so there is no option to mark it as answered

(not sure if you can set it to closed at all, is there an option at the very top, near the first post?).

If there is an option to close the thread in any way, do so. If not, don't worry.

Regards,

Stefan

Re: Dates in Variables but Formatting Issue In Textbox

Peter_Brunner — Wed, 15 Jun 2016 23:11:01 GMT

Hi Stefan,

I have checked but there is no way I can see to close it ...I have looked under Edit but nothing to fix this,

also I have re loaded a new discussion and I noticed that the mark for discussion box is ticked by default ??

and why would it let me mark it Helpful if it was not a question?

anyway I will double check next discussion I do , it seems very erratic very frustrating not knowing !

sorry Stefan

thanks again

regards Peter

Re: Dates in Variables but Formatting Issue In Textbox

sunny_talwar — Thu, 16 Jun 2016 00:05:30 GMT

Hi Peter -

Marking correct answer is one way to reward as well as highlight useful responses. But there is another way using helpful answer. You have marked one of my response as helpful, I suggest marking Stefan's response/s as helpful as well. You can mark as many helpful as you want so mark all those responses you found helpful.

Best,

Sunny

Re: Dates in Variables but Formatting Issue In Textbox

Peter_Brunner — Thu, 16 Jun 2016 00:09:41 GMT

Hi Sunny,

good suggestion..... I have done that now.

thanks regards Peter

Re: Dates in Variables but Formatting Issue In Textbox

sunny_talwar — Thu, 16 Jun 2016 00:13:07 GMT

Thank you Peter!

Best,

Sunny