Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dividing the value of two expressions

Hi,

I am working in a chart. and the first two values in the chart are numbers resulting from each sums.

and I want to do column(1) / column(2).

but whenever i use + - / it says I am using bad field name.

How do I deal with this???? this is very werid

Thanks!!

1 Solution

Accepted Solutions
squeakie_pig
Creator II
Creator II

If for some reason that is still not working (and it should), you can also use the expression names

[name you called column 1] / [name you called column 2]

eg. in my example it would be: [Actual Stuff] / [Not Actual Stuff]

even though column(1)/column(2) works just as well for me here.

columns.png

View solution in original post

4 Replies
Clever_Anjos
Employee
Employee

Did you try exactly column(1) / column(2) ?

sunny_talwar

Can you share a screenshot of what you have trying?

squeakie_pig
Creator II
Creator II

If for some reason that is still not working (and it should), you can also use the expression names

[name you called column 1] / [name you called column 2]

eg. in my example it would be: [Actual Stuff] / [Not Actual Stuff]

even though column(1)/column(2) works just as well for me here.

columns.png

Not applicable
Author

Hi Guys,

Thank you I just figured it out.

It says bad field when I type in the operational symbols but when I finish up the rest of the script it says expression ok. so I guess I just had to finish the entire script!

Thank you all!