topic Re: How to filter data in a pivot or a table in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-pivot-or-a-table/m-p/556803#M207868 <HTML><HEAD></HEAD><BODY><P>You can add a filter to the expressions in your pivot charts. Suppose you have an expression sum(Sales). You can change it into sum({&lt;DateGroup={'Current year'}&gt;}Sales). This will first calculate a set for the chart that filters the records on the field DateGroup to consider only those with value 'Current year'. This set is then used by the chart to calculate the sums of the field Sales for the chart dimensions.</P></BODY></HTML> Tue, 15 Oct 2013 05:30:37 GMT Gysbert_Wassenaar 2013-10-15T05:30:37Z How to filter data in a pivot or a table https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-pivot-or-a-table/m-p/556802#M207867 <HTML><HEAD></HEAD><BODY><P>I have a table with 3 date groups. Current year , previous year and forecast. I need to make 3 identical tables pivot tables one with each date type as a filter. meaning one for current year , one for previous year etc. </P></BODY></HTML> Mon, 14 Oct 2013 20:50:59 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-pivot-or-a-table/m-p/556802#M207867 2013-10-14T20:50:59Z Re: How to filter data in a pivot or a table https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-pivot-or-a-table/m-p/556803#M207868 <HTML><HEAD></HEAD><BODY><P>You can add a filter to the expressions in your pivot charts. Suppose you have an expression sum(Sales). You can change it into sum({&lt;DateGroup={'Current year'}&gt;}Sales). This will first calculate a set for the chart that filters the records on the field DateGroup to consider only those with value 'Current year'. This set is then used by the chart to calculate the sums of the field Sales for the chart dimensions.</P></BODY></HTML> Tue, 15 Oct 2013 05:30:37 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-pivot-or-a-table/m-p/556803#M207868 Gysbert_Wassenaar 2013-10-15T05:30:37Z Re: How to filter data in a pivot or a table https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-pivot-or-a-table/m-p/556804#M207869 <HTML><HEAD></HEAD><BODY><P>Great i ll check it out and let you know </P></BODY></HTML> Tue, 15 Oct 2013 21:52:15 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-a-pivot-or-a-table/m-p/556804#M207869 2013-10-15T21:52:15Z