topic Re: Condition for Dimension in QlikView https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45392#M7589 <HTML><HEAD></HEAD><BODY><P>Here is my sample data </P></BODY></HTML> Mon, 19 Mar 2018 05:34:48 GMT upaliwije 2018-03-19T05:34:48Z Condition for Dimension https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45390#M7587 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I have apivot table in my QV Doc. There I have 3 Dimensions namely&nbsp; Policy_no ,Name and Year.&nbsp;&nbsp; Premium Amount as measure.</P><P>My Pivot Table is shown below</P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196679_Screenshot_1.png" style="height: auto;" /></P><P>My Problem is here I want to show records which has a premium against year 2017. In other words records shown in 1,2 5 should be in the Pivot table and 3,4 should not appear. Pls help me to do this</P></BODY></HTML> Mon, 19 Mar 2018 05:17:24 GMT https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45390#M7587 upaliwije 2018-03-19T05:17:24Z Re: Condition for Dimension https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45391#M7588 <HTML><HEAD></HEAD><BODY><P>Could you share your sample qvw?</P></BODY></HTML> Mon, 19 Mar 2018 05:20:23 GMT https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45391#M7588 tresB 2018-03-19T05:20:23Z Re: Condition for Dimension https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45392#M7589 <HTML><HEAD></HEAD><BODY><P>Here is my sample data </P></BODY></HTML> Mon, 19 Mar 2018 05:34:48 GMT https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45392#M7589 upaliwije 2018-03-19T05:34:48Z Re: Condition for Dimension https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45393#M7590 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P>sum({&lt;POLICY_NO={"=Index(Concat(Distinct YEAR,','), '2017')"}&gt;}Premium)</P></BODY></HTML> Mon, 19 Mar 2018 06:03:01 GMT https://community.qlik.com/t5/QlikView/Condition-for-Dimension/m-p/45393#M7590 tresB 2018-03-19T06:03:01Z