Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!