topic Re: To show number and date (format) in same column in QlikView

To show number and date (format) in same column

sunitha_chellaiah — Wed, 29 May 2019 09:37:54 GMT

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.

Re: To show number and date (format) in same column

Anil_Babu_Samineni — Wed, 29 May 2019 12:57:51 GMT

Why can't?

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

Re: To show number and date (format) in same column

sunitha_chellaiah — Thu, 30 May 2019 10:40:25 GMT

Not 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.

Re: To show number and date (format) in same column

Brett_Bleess — Mon, 01 Jul 2019 21:38:11 GMT

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/FormattingFunctions/Dual.htm

Design Blog posts on Dual:

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

Regards,
Brett