topic Help in generating a fixed (locked) filter in QlikView https://community.qlik.com/t5/QlikView/Help-in-generating-a-fixed-locked-filter/m-p/1282218#M870057 <HTML><HEAD></HEAD><BODY><P>Good evening , I’m realatively new in Qlikview and having some issues with one particular expression. </P><P>I’m trying to create&nbsp; an expression that contains a fixed (locked) fiter so that it doesn’t matter which filter I select the values obtained in the expression should remain the same. Currently, I’m using the following expression: </P><P></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 9.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d;">=Count(DISTINCT TOTAL(if([AÑO]='2014' and wildmatch([#CENTRO],'C*'),MATERIAL) ))</SPAN></P><P></P><P>What I’m trying to do is that it shouldn’t matter if I select one supplier, client or city in particular, that expression should always remain the same. </P><P></P><P>I’d appreciate any help I can get, thanks a lot in advance guys!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Help in generating a fixed (locked) filter https://community.qlik.com/t5/QlikView/Help-in-generating-a-fixed-locked-filter/m-p/1282218#M870057 <HTML><HEAD></HEAD><BODY><P>Good evening , I’m realatively new in Qlikview and having some issues with one particular expression. </P><P>I’m trying to create&nbsp; an expression that contains a fixed (locked) fiter so that it doesn’t matter which filter I select the values obtained in the expression should remain the same. Currently, I’m using the following expression: </P><P></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 9.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d;">=Count(DISTINCT TOTAL(if([AÑO]='2014' and wildmatch([#CENTRO],'C*'),MATERIAL) ))</SPAN></P><P></P><P>What I’m trying to do is that it shouldn’t matter if I select one supplier, client or city in particular, that expression should always remain the same. </P><P></P><P>I’d appreciate any help I can get, thanks a lot in advance guys!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-in-generating-a-fixed-locked-filter/m-p/1282218#M870057 2020-11-25T16:16:04Z Re: Help in generating a fixed (locked) filter https://community.qlik.com/t5/QlikView/Help-in-generating-a-fixed-locked-filter/m-p/1282219#M870058 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: Helvetica, sans-serif; font-size: 12px;">If your expression works, try this:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: Helvetica, sans-serif; font-size: 12px;">=Count( <STRONG>{1}</STRONG> DISTINCT TOTAL(if([AÑO]='2014' and wildmatch([#CENTRO],'C*'),MATERIAL) ))</SPAN></P></BODY></HTML> Mon, 05 Dec 2016 18:45:23 GMT https://community.qlik.com/t5/QlikView/Help-in-generating-a-fixed-locked-filter/m-p/1282219#M870058 Anonymous 2016-12-05T18:45:23Z