Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

How to summary data same excel?

I summary data from qlikview as green part but result is not true, how to I got result same as excel summary?

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be Ceil(Sum(Sales))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

For me QlikView calculates 39987 for the integer part not 39986 as you have.... do you have a  sample QlikView app to share so we can find out why your calculation doesn't add up to 39987?

Anil_Babu_Samineni

May be Ceil(Sum(Sales))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marcus_malinow
Specialist III
Specialist III

How about Sum(Ceil(Sales))