topic how to filter field value based on another field value in QlikView

how to filter field value based on another field value

yasoharigk — Thu, 12 Mar 2015 12:21:26 GMT

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

Re: how to filter field value based on another field value

Gysbert_Wassenaar — Thu, 12 Mar 2015 17:51:01 GMT

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.

Re: how to filter field value based on another field value

maxgro — Thu, 12 Mar 2015 23:03:42 GMT

PFA

Re: how to filter field value based on another field value

Thu, 12 Mar 2015 23:49:27 GMT

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