topic Re: filtering straight table expression in QlikView

filtering straight table expression

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

how can i filter my straight table expression

for >=0 and <0 values

Suggest qlikkss

Re: filtering straight table expression

vishsaggi — Fri, 24 Mar 2017 15:38:57 GMT

What is the issue here? Can you share your expr you are trying on?

Re: filtering straight table expression

stonecold111 — Fri, 24 Mar 2017 15:45:40 GMT

sum(colum1)-sum(column2)-max(column3)

Re: filtering straight table expression

stonecold111 — Fri, 24 Mar 2017 15:47:06 GMT

4 dimensions and around 10 expressions in straight table

Re: filtering straight table expression

devarasu07 — Fri, 24 Mar 2017 15:54:14 GMT

Hi,

Have u tried below Search expression methods?

The Search String

when you have issues in qlik always try to share your issues via sample data with mock app then others can easy to check and helps to resolve your issue.

Thanks,

Deva

Re: filtering straight table expression

vishsaggi — Fri, 24 Mar 2017 18:30:54 GMT

Can you share a sample app and the issue highlighted. IT would be easy to work on.

Re: filtering straight table expression

Anil_Babu_Samineni — Sat, 25 Mar 2017 16:19:07 GMT

May be this?

Sum({<Values = {'<=0'}>} Values)

Sum({<Values = {'>=0 <0'}>} Values) // I am not sure, How this works this case. May be provide sample data

Re: filtering straight table expression

Anonymous — Sat, 25 Mar 2017 17:05:26 GMT

I have an Idea

filter the table by bottun

Re: filtering straight table expression

stonecold111 — Sun, 26 Mar 2017 13:44:03 GMT

searchable in straight table not working

I posted sample data here .. plz have a look into that

Re: filtering straight table expression

stonecold111 — Sun, 26 Mar 2017 13:45:33 GMT

its not field . its an expression

searchable in straight table not working

I posted sample data here .. plz have a look into that

Re: filtering straight table expression

stonecold111 — Sun, 26 Mar 2017 13:46:16 GMT

searchable in straight table not working

I posted sample data here .. plz have a look into that

Re: filtering straight table expression

Anil_Babu_Samineni — Sun, 26 Mar 2017 16:16:37 GMT

In fact, You should not use the Wild card like *<0*. It should be <0 and i am not sure why do you need -1 over the expression. I've removed and applied it's working

(sum(colum1)-sum(column2)-sum(column3))