topic Re: Help with the Condition in Table Chart in QlikView

Help with the Condition in Table Chart

markgraham123 — Thu, 11 Jun 2015 15:59:58 GMT

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

Anonymous — Thu, 11 Jun 2015 16:05:23 GMT

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 — Thu, 11 Jun 2015 16:13:21 GMT

Hi Jeba,

I tried that, but no change.

Anonymous — Thu, 11 Jun 2015 16:16:55 GMT

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

markgraham123 — Thu, 11 Jun 2015 16:23:40 GMT

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.

Anonymous — Thu, 11 Jun 2015 16:26:43 GMT

Hi Mark,

Please close the thread

Thanks & Regards

Jeba