Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sunitha_chellaiah
Partner - Creator
Partner - Creator

To show number and date (format) in same column

Hi All,

Is it possible to show number and date format in the same column in straight table. I have tried in front end as well as back end but at a time it is taking only format. Also after exporting to excel, it is getting converted to text.

Need your suggestions.

Thanks.

3 Replies
Anil_Babu_Samineni

Why can't?

Num(DateFormat) & '&' & Date(DateFormat)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunitha_chellaiah
Partner - Creator
Partner - Creator
Author

Not like that. 

See for example I have the following table

ASNColumn1
Header2-5-2019
Line3.4
Line3.5
Line5.5
Header10-3-2019
Line7.8

 

Column1 has date as well as numbers. while I export this table in excel , this column is getting converted to text. I want date format and number format as it is even I export it to excel.

 

Brett_Bleess
Former Employee
Former Employee

Hopefully one of these may help you out here:

Help regarding Dual function:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/For...

Design Blog posts on Dual:

https://community.qlik.com/t5/Qlik-Design-Blog/Dual-Exists-Useful-Functions/ba-p/1465290

Regards,
Brett

 

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.