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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

How to display only even dollar amounts in a Chart

I have several different dollar amounts in a field.  I would like to only display the ones that are even amounts when no cents.  How can I display only those values?  I do not want to round the values, but only show those that do not have any values with cents.  For example, $100, $200, $25, but not $100.01, $200.23, $25.25.

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

May be as attached:

View solution in original post

7 Replies
oknotsen
Master III
Master III

Change the format of the result to a format without decimals.

For example:

num(expressionHere,'$ #,##0;$ -#,##0')

May you live in interesting times!
cliff_clayman
Creator II
Creator II
Author

I first need to know how to get my results of just the even dollar amounts.  I do not want to format the values.  I just want to display only the even dollar amounts.

sunny_talwar

May be this:

If(Frac(Value) = 0, Value)

sunny_talwar

Have you tried the one I mentioned below?

cliff_clayman
Creator II
Creator II
Author

I don't seem to be getting the proper results returned when using that.  I know I have a lot more than what is being returned.

trdandamudi
Master II
Master II

May be as attached:

sunny_talwar

Check Thirumala‌ solution updated with my expression

Capture.PNG