Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter in straight table

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?

4 Replies
tresesco
MVP
MVP

May be like :

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

Not applicable
Author

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?

MayilVahanan

HI

May be try like this

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

or

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

Thanks & Regards,
Mayil Vahanan R
tresesco
MVP
MVP

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.