Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Change data Type of a Dimension from Text to Number

Anyone Knows How do i change Data Type of a dimension in the GUI?

When I export the table to Excel and it comes out as Text and i need it to be Number or Integer.

I tried Num / Num# and no success.

Thanks Onn Bar

4 Replies

Re: Change data Type of a Dimension from Text to Number

Can you share your sample data file?

Re: Change data Type of a Dimension from Text to Number

You can't change the data type, only the formatting. But exporting to excel doesn't also export the formatting. You can either use a macro to export to excel and change the formatting. Or you can manually change the formatting in excel.


talk is cheap, supply exceeds demand

Re: Change data Type of a Dimension from Text to Number

Hi,

can you post sample data which you want to convert in number.

Regards,
Prashant Sangle
Not applicable

Re: Change data Type of a Dimension from Text to Number

If you set the data type under Settings- Document Properties- Number and make sure the field you want to change is set to the format you want it in. Exporting to excel seems to pick up this formatting.

Community Browser