Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
in_kkumar31
Contributor II
Contributor II

Unable to add a Division Expression in QlikSense

Hi,

I am fairly new to Qliksense, i have a very basic problem in division. I am trying to divide two integers in a table. a/b ,

but when i do this i am not getting correct results. i tried to do this in the load script , but ended up in getting the same output. Would be eager to know where i am going wrong.

Rgds,

Krishna    

4 Replies
Digvijay_Singh

Can you share sample and the output you are getting, the current problem description is not enough to understand the real problem you are facing!

zebhashmi
Specialist
Specialist

=Fieldnane1/Filedname2

or

=Column(1)/Column(2)

should work

clondono
Creator III
Creator III

Check the format of the fields you are dividing (a/b). If they are formatted as text or string you cannot perform the division.  Also, like Jahanzeb said, if you are using the integers in the table as columns, you can use:

=Column(1)/Column(2)

or you can use

=Column(NameofColum1)/Column(NameofColumn2)

Best if you can share screenshot of the expression and/or the table.

in_kkumar31
Contributor II
Contributor II
Author

Hi, Thanks for your responses...  there is nothing wrong in the formula as it worked when i used the original copy of the dashbaord.  I removed some of the autogenerated scripts to make it more cleaner ... it seems it removed some of joins and field names and that was actually causing the issues.