topic reduce value's in $Field listbox in QlikView https://community.qlik.com/t5/QlikView/reduce-value-s-in-Field-listbox/m-p/647897#M237230 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I was wondering if anyone knows how to reduce the values of a $Field listbox.</P><P>Normaly i would say: if(match(XDimension,'1',2'),XDimension)</P><P></P><P>But because i want to show $Field -which i use for a dynamic chart-, this is not applicable. </P><P></P><P>I would like to achive this because it currently shows all the fields of the model.</P><P></P><P>Any ideas?</P><P></P><P>Thanks in advance!</P><P></P><P>Gr!</P></BODY></HTML> Mon, 08 Sep 2014 11:57:35 GMT 2014-09-08T11:57:35Z reduce value's in $Field listbox https://community.qlik.com/t5/QlikView/reduce-value-s-in-Field-listbox/m-p/647897#M237230 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I was wondering if anyone knows how to reduce the values of a $Field listbox.</P><P>Normaly i would say: if(match(XDimension,'1',2'),XDimension)</P><P></P><P>But because i want to show $Field -which i use for a dynamic chart-, this is not applicable. </P><P></P><P>I would like to achive this because it currently shows all the fields of the model.</P><P></P><P>Any ideas?</P><P></P><P>Thanks in advance!</P><P></P><P>Gr!</P></BODY></HTML> Mon, 08 Sep 2014 11:57:35 GMT https://community.qlik.com/t5/QlikView/reduce-value-s-in-Field-listbox/m-p/647897#M237230 2014-09-08T11:57:35Z Re: reduce value's in $Field listbox https://community.qlik.com/t5/QlikView/reduce-value-s-in-Field-listbox/m-p/647898#M237231 <HTML><HEAD></HEAD><BODY><P>Try it with expressions in chart/listbox like these:</P><P></P><P>= if(match($Field, 'Monat', 'Jahr'), $Field)</P><P>= if($Table = 'Kalender', $Field)</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 08 Sep 2014 13:28:46 GMT https://community.qlik.com/t5/QlikView/reduce-value-s-in-Field-listbox/m-p/647898#M237231 marcus_sommer 2014-09-08T13:28:46Z Re: reduce value's in $Field listbox https://community.qlik.com/t5/QlikView/reduce-value-s-in-Field-listbox/m-p/647899#M237232 <HTML><HEAD></HEAD><BODY><P>Thanks allot. i thought this din't worked with $Field but it did indeed work!</P></BODY></HTML> Mon, 08 Sep 2014 15:38:54 GMT https://community.qlik.com/t5/QlikView/reduce-value-s-in-Field-listbox/m-p/647899#M237232 2014-09-08T15:38:54Z