Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master II
Master II

May be as attached:

View solution in original post

7 Replies
Highlighted
Master III
Master III

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

For example:

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

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
Creator II
Creator II

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.

Highlighted

May be this:

If(Frac(Value) = 0, Value)

Highlighted

Have you tried the one I mentioned below?

Highlighted
Creator II
Creator II

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.

Highlighted
Master II
Master II

May be as attached:

View solution in original post

Highlighted

Check Thirumala‌ solution updated with my expression

Capture.PNG