Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 sunitha_chellai
		
			sunitha_chellaiHi 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.
Why can't?
Num(DateFormat) & '&' & Date(DateFormat)
 sunitha_chellai
		
			sunitha_chellaiNot like that.
See for example I have the following table
| ASN | Column1 | 
| Header | 2-5-2019 | 
| Line | 3.4 | 
| Line | 3.5 | 
| Line | 5.5 | 
| Header | 10-3-2019 | 
| Line | 7.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.
.png) Brett_Bleess
		
			Brett_Bleess
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hopefully one of these may help you out here:
Help regarding Dual function:
Design Blog posts on Dual:
https://community.qlik.com/t5/Qlik-Design-Blog/Dual-Exists-Useful-Functions/ba-p/1465290
Regards,
Brett
