topic Re: Filter in straight table in QlikView

Filter in straight table

Thu, 17 Oct 2013 15:59:13 GMT

We created straight table .We need to use filter : datefield<Today and sum(opensumfield)>0. The condition we created doesnt work properly: If(datefield<Today(),1,0)and If(opensumfield>0,1,0). We get also -1 values. What is wrong with it?

Re: Filter in straight table

tresB — Thu, 17 Oct 2013 16:08:20 GMT

May be like :

=If(datefield<today() AND opensumfield>0 , 1,0)

Re: Filter in straight table

Fri, 18 Oct 2013 11:22:06 GMT

And if I want to use this condition so that the chart will show only those records, which fulfill the condition? How to do this?

Re: Filter in straight table

MayilVahanan — Fri, 18 Oct 2013 11:26:36 GMT

May be try like this

= Sum({<Datefield = {"<$(=today())"}, UniqueId = {"=Sum(opensumfield) > 0"}>}opensumfield)

= Sum({<Datefield = {"<$(=today())"}, opensumfield= {"> 0"}>}opensumfield)

Re: Filter in straight table

tresB — Fri, 18 Oct 2013 11:45:45 GMT

Then use calculated dimension with expression : =If(datefield<today() AND opensumfield>0 , datefield)

and then check 'Suppress When Value Is Null' in the dimension tab.

Then only the valid dates will be displayed in the dimension column.