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: 
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