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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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