Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
profilejamesbond
Creator II
Creator II

Qlik Sense Chart Dimension - Shows decimal days instead of absolute days values

Hi,

I made a chart in Qlik Sense but it shows the days in Decimals, while the days should be in Absolute values in a Dimension.

The Days values are correct like 1, 2, 3, 4, ... while in the Chart it comes like 1, 1.5, 2, 2.5, 3, 3.5, 4, ...

How to convert these decimal days into absolute days in Qlik Sense ?

 

Thanks

Labels (6)
2 Replies
Bhuvi
Partner - Contributor III
Partner - Contributor III

Hello,

Try doing this,

In the edit mode click on Data open the dimension and write as Num(dimension,'#0') in the existing dimension.

Thank you

profilejamesbond
Creator II
Creator II
Author

Hi @Bhuvi,

It is not working, I have already tried with number format and floor etc option.

The problem is the Responsive Behavior of Qlik Sense, when you make bigger then the values are coming with decimal without any format applying and when the chart is small the values are ok with absolute format.

 

profilejamesbond_0-1677664795620.png