Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Help with the Condition in Table Chart

Hi,

i have velocity column, where i need the new velocity column whose values are greater than 0.1

I was doing with "If" statement.....

11.png

1 Solution

Accepted Solutions
Anonymous
Not applicable

Try if(column(1)>0.1%,column(1)

View solution in original post

5 Replies
Anonymous
Not applicable

Hi Mark,

Is Rel % is the dimension you have in your app? I don't think so.

If not please use like below

If (column(1)>=0.2,column(1)

Try and confirm

Regards

Jeba

markgraham123
Specialist
Specialist
Author

Hi Jeba,

I tried that, but no change.

22.png

Anonymous
Not applicable

Try if(column(1)>0.1%,column(1)

markgraham123
Specialist
Specialist
Author

Hi jeba,

I just unchecked "%" in number tab and gave the condition "If (column(1)>=0.001,column(1))" instead of "0.1", it

worked.

In the end, after all the results were fetched i'm checking the "%" option.

This way it worked.

Thank you jeba, u accurately predicted it.

Kudos.

33.png

Anonymous
Not applicable

Hi Mark,

Please close the thread

Thanks & Regards

Jeba