Skip to main content
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Handling data types and formats in QlikView 05/14

This session will cover how to work with data types and data formats in QlikView, including how to work with dual values and dollar expansions. It will also touch on how to implement regionally adapted settings for application users. There will also be some examples of common issues when working with formatted values in QlikView.


For best viewing, we recommend you set the highest video resolution.

Q&A - Troubleshooting QlikView Server with the System Monitor

Q: What data type and format does QlikView expect in calculated dimensions?

A: QlikView always works with dual values, and with the underlying numerical value if possible. Calculated dimensions can easily become too complex to interpret or predict, and thereby the outcome can sometimes be unexpected in the chart object.

Q: How does Class() function generate the interval references?

A: Class() generates interval based on an expression value, for example this QlikCommunity link might clarify the basics

Q: I always have a problem when I try to use a ' ' (space) as thousand separator?

A: The white space separator is by default a non-breaking space, in order to prohibit a large numerical value to text wrap over several lines. Non-breaking space has the integer value of 160, so it can be generated with chr(160). The value can also be copied and pasted if you have if visible in your application.

Q: When using set expression, can a date be referred to as string or numerical value?

A: Either text or numerical value works, like for example {$ <Date={“2014-05-15”}>} or {$ <Date={42774}>}. Text value is easier to interpret, so this would be the recommended approach. Keep in mind that values in set expressions must be double quoted, as seen in Reference Manual examples.

Q: Why is there a underlying decimal value when a date value is loaded from Excel file?

A: The date value in Excel is actually a timestamp value that is formatted to be presented as a date value.

Q: Why will QlikView sometimes convert Char values defined in SQL Server 200X into different numeric values? 

A: This is not a generic issue that we are aware of. For database connections there is always a driver handling the data between the source and QlikView, so a coding mismatches could come from bad configuration or other issues with the driver.

Q: Can QlikView handle two date formats in the same application, such as 12-1-1981 and 12/1/1981?

A: An application in QlikView always has a defined format, and it is recommended to try and follow this format. There are several different ways of defining multiple formats in QlikView. Search QlikCommunity or QlikView Demo site for example applications. See for example

Q: Is there any great performance loss when loading a bulk of datetimes and doing the conversion in the load script?

A: All calculations cost time and resources. If the calculations can be done during reload it is a onetime effort, while in the front end application it will occur repeatedly when application is used. In general it should always be more beneficial performance wise to make operations during reload.

Q: What is the difference between using single quotation ' ' and double " " in set analysis?

A: Double quotation will make an exact match of the specified string. This is the expected format for set expression values.

0 Replies