Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
=Fieldnane1/Filedname2
or
=Column(1)/Column(2)
should work
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.
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.