Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Why can't?
Num(DateFormat) & '&' & Date(DateFormat)
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.
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