Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

in_kkumar31
New Contributor

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    

Tags (1)
4 Replies
Digvijay_Singh
Honored Contributor III

Re: Unable to add a Division Expression in QlikSense

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
Valued Contributor

Re: Unable to add a Division Expression in QlikSense

=Fieldnane1/Filedname2

or

=Column(1)/Column(2)

should work

clondono
Contributor III

Re: Unable to add a Division Expression in QlikSense

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
New Contributor

Re: Unable to add a Division Expression in QlikSense

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.

Community Browser