how to filter field value based on another field value

[yasoharigk]

I need to hide the row where field1=0 and field2 =0. but if the user want to show all then i want to show all but if any one field is 0 then it should bot hide. how can i implement this.

SN	Field 1	Field  2
1	0	0
2	0	124314
3	13242134	0
4	0	0
5	452345245	23452345234
6	3452345	23545

Show ALL

Here i want to see row 2,3,5and 6

Where ever both fields are 0 then only hide. if any one field 0 then it should display. if I clcik on Show all then it will show all the records.

if i click hide then it will hide where field1=0 and field2=0

[Gysbert_Wassenaar]

Create a straight table with SN as dimension and sum([Field 1]) and sum([Field 2]) as expressions. As long as the Suppress Zero Values option is enabled the straight table will behave exactly like you want.

[maxgro]

PFA

[#4]

Hi,

     Just check-in 'Suppress zero values' in Presentation tab. By default, it will be in checked-in mode If not, do check in. It will work in almost all type of basic charts in QlikView.

Regards

Lathaa