Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

try
New Contributor II

No Number tab to adjust the format of a field

In Qlik Sense, I cannot find an easy way to change the format of a field. In QlikView, there was the Number tab in the chart properties that allowed one to set how a field appeared. There seems to be no options like this in Sense. How can changing the format of a field be achieved?

1 Solution

Accepted Solutions
Not applicable

Re: No Number tab to adjust the format of a field

What type of Chart you tried, for example in a Bar Chart under Measures you have this

Sense Number.png

2 Replies
Not applicable

Re: No Number tab to adjust the format of a field

What type of Chart you tried, for example in a Bar Chart under Measures you have this

Sense Number.png

Not applicable

Re: No Number tab to adjust the format of a field

I had the same problem trying to work with the table. I ended up changing the expression from just the name of my column:

[timestamp_disposition]

to cast it to the same date format that you would get by using the number tab like follows:

=DATE([timestamp_disposition],'M/D/YYYY h:mm:ss[.fff] TT')

Per Daniel's advice you can do that formatting for your columns ahead of time by making them Measures and then use the Measure in the table/chart instead of the column itself to get around the issue.