topic Re: formatting what is displayed on current selection box in QlikView

formatting what is displayed on current selection box

ali_hijazi — Thu, 13 Nov 2014 08:38:11 GMT

Hello got a date field which is numbers (QlikView format)

I have a button which selects in this field as follows

='>= ' & $(vFromDate) & ' <= ' & $(vToDate)

the result is fine but what the end user sees is as follows:

End users are not developers

can this be translated to something like >= 1/1/2014 <= 10/29/2014 ?

Please advise

Re: formatting what is displayed on current selection box

vardhancse — Thu, 13 Nov 2014 08:39:40 GMT

can change the number format to date format for that field.

As what ever data in a field, will be displayed in current selection.

Re: formatting what is displayed on current selection box

sujeetsingh — Thu, 13 Nov 2014 08:40:45 GMT

Change the date format using date() date() functions.

Re: formatting what is displayed on current selection box

vinay_hg — Thu, 13 Nov 2014 08:42:35 GMT

format that date fields/variables in script using Date(vfromdate,'DD/MM/YYYY') or format variable in front end.

Re: formatting what is displayed on current selection box

vardhancse — Thu, 13 Nov 2014 08:44:13 GMT

what is the variable vFromDate and vToDate.

Re: formatting what is displayed on current selection box

ali_hijazi — Thu, 13 Nov 2014 08:50:20 GMT

vFromDate = 41640

vToDate = 41941

I'm selecting on Snapshot_Date which has the above format (numbers)

Re: formatting what is displayed on current selection box

vardhancse — Thu, 13 Nov 2014 08:52:17 GMT

change the number format for Snapshot_Date in document properties->number<tab>->date

Re: formatting what is displayed on current selection box

ali_hijazi — Thu, 13 Nov 2014 09:08:35 GMT

this only formats the display of SNAPSHOT_DATE

Re: formatting what is displayed on current selection box

mdmukramali — Thu, 13 Nov 2014 09:16:54 GMT

Dear,

Can you check the attached file.

i hope it will help u.

Thanks,

Mukram

Re: formatting what is displayed on current selection box

ashfaq_haseeb — Thu, 13 Nov 2014 11:13:28 GMT

Hi,

Ali I think that not directly possible.

Instead you can try by adding 1 proper date filed.

And hide numeric date field selection by using hide prefix statement.

And add field event trigger to select similar selection in proper date field.

Hope it helps.

Regards

ASHFAQ

Re: formatting what is displayed on current selection box

ali_hijazi — Thu, 13 Nov 2014 11:16:04 GMT

ah okay sounds smart solution

I know the suggestions that were proposed here are not valid

Re: formatting what is displayed on current selection box

mario-sarkis — Thu, 13 Nov 2014 13:36:05 GMT

i have a field that contain a strating time as >>> '7423590' i need to show it like this 7:42:32:90 am (hours ,minutes,seconds,milliseconds)

and another filed that contain the ending time as >>'7435789' i need to show it like this 7:43:57:89 am (hours, minutes,seconds,milliseconds)

and finaly i need a field that will show me the diffrence time between the starting and the ending time .

Thank you,

Re: formatting what is displayed on current selection box

ashfaq_haseeb — Thu, 13 Nov 2014 14:04:45 GMT

This is what you need.

=interval((Time#(Left(Repeat('0',6-Len(7435789))&7435789,1) & ':' & Mid(Repeat('0',6-Len(7435789))&7435789,2,2)& ':' &mid(Repeat('0',6-Len(7435789))&7435789,4,2)& ':' &right(Repeat('0',6-Len(7435789))&7435789,2),'hh:mm:ss:ff'))-(Time#(Left(Repeat('0',6-Len(7423590))&7423590,1) & ':' & Mid(Repeat('0',6-Len(7423590))&7423590,2,2)& ':' &mid(Repeat('0',6-Len(7423590))&7423590,4,2)& ':' &right(Repeat('0',6-Len(7423590))&7423590,2),'hh:mm:ss:ff')))

Regards

ASHFAQ

Re: formatting what is displayed on current selection box

mario-sarkis — Thu, 13 Nov 2014 16:29:07 GMT

Hi ASHFAQ,

Thank you for your help,it works Successfully

but i used 8-Len instead of 6-Len

Regards

Mario

Re: formatting what is displayed on current selection box

ali_hijazi — Thu, 13 Nov 2014 16:31:04 GMT

ah I just saw it

I also sent you an email

almost the same

Re: formatting what is displayed on current selection box

ashfaq_haseeb — Thu, 13 Nov 2014 17:25:39 GMT

Hi can u mark it as correct

Regards

ASHFAQ

Re: formatting what is displayed on current selection box

mario-sarkis — Fri, 14 Nov 2014 06:48:56 GMT

hehe Thank you ALI

Re: formatting what is displayed on current selection box

mario-sarkis — Fri, 14 Nov 2014 06:52:26 GMT

of caurse i can but where i am sorry i Am a fresh user here