Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

formatting what is displayed on current selection box

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:

test.png

End users are not developers

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

Please advise

I can walk on water when it freezes
17 Replies
ali_hijazi
Partner - Master II
Partner - Master II
Author

ah okay sounds smart solution

I know the suggestions that were proposed here are not valid

I can walk on water when it freezes
mario-sarkis
Creator II
Creator II

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,

ashfaq_haseeb
Champion III
Champion III

Hi

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

mario-sarkis
Creator II
Creator II

Hi ASHFAQ,

Thank you for your help,it works Successfully 

but i used 8-Len instead of 6-Len

Regards

Mario

ali_hijazi
Partner - Master II
Partner - Master II
Author

ah I just saw it

I also sent you an email

almost the same

I can walk on water when it freezes
ashfaq_haseeb
Champion III
Champion III

Hi can u mark it as correct

Regards

ASHFAQ

mario-sarkis
Creator II
Creator II

hehe Thank you ALI

mario-sarkis
Creator II
Creator II

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