topic filtering dimension in QlikView https://community.qlik.com/t5/QlikView/filtering-dimension/m-p/701751#M253269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the Question 1 to 15 in the pivot table and i want to display only Question 1 to 10. How can i filter the questions in dimensions.</P><P></P><P>Please help.</P><P></P><P><IMG alt="filter.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/61618_filter.png" style="width: 620px; height: 431px;" /></P></BODY></HTML> Thu, 03 Jul 2014 06:46:05 GMT 2014-07-03T06:46:05Z filtering dimension https://community.qlik.com/t5/QlikView/filtering-dimension/m-p/701751#M253269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the Question 1 to 15 in the pivot table and i want to display only Question 1 to 10. How can i filter the questions in dimensions.</P><P></P><P>Please help.</P><P></P><P><IMG alt="filter.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/61618_filter.png" style="width: 620px; height: 431px;" /></P></BODY></HTML> Thu, 03 Jul 2014 06:46:05 GMT https://community.qlik.com/t5/QlikView/filtering-dimension/m-p/701751#M253269 2014-07-03T06:46:05Z Re: filtering dimension https://community.qlik.com/t5/QlikView/filtering-dimension/m-p/701752#M253270 <HTML><HEAD></HEAD><BODY><P>just make it a calculated dimension</P><P></P><P>if (Match(Questions,'Q1','Q2',..'Q10'),Questions)</P><P></P><P>And then tick the check box "Suppress when Value is NULL'</P></BODY></HTML> Thu, 03 Jul 2014 06:48:41 GMT https://community.qlik.com/t5/QlikView/filtering-dimension/m-p/701752#M253270 2014-07-03T06:48:41Z