https://community.qlik.com/t5/App-Development/Filters-not-working-in-Qlikview-stright-table-when-i-use-1-or/m-p/1907523#M74788 <P>Hi,<BR />Below my input columns and i mentioned required output as well. please help me in finding the output in Stright table.<BR />Input table:<BR />L1&nbsp; &nbsp; L2&nbsp; &nbsp; User_ID&nbsp; &nbsp; Month&nbsp; &nbsp; &nbsp;year<BR />A&nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; A1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; AB&nbsp; &nbsp; &nbsp;A2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan&nbsp; &nbsp; &nbsp; &nbsp;2022<BR />A&nbsp; &nbsp; &nbsp; AC&nbsp; &nbsp; &nbsp;A3</P> <P>A&nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp;A11<BR />A&nbsp; &nbsp; &nbsp; AB&nbsp; &nbsp; &nbsp;A21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; AC&nbsp; &nbsp; &nbsp;A31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; &nbsp;AA&nbsp; &nbsp; &nbsp;A4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; &nbsp;AB&nbsp; &nbsp; &nbsp;A5<BR />A&nbsp; &nbsp; &nbsp; &nbsp; AC&nbsp; &nbsp; &nbsp;A6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />B&nbsp; &nbsp; &nbsp; &nbsp; BA&nbsp; &nbsp; &nbsp; B1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />B&nbsp; &nbsp; &nbsp; &nbsp; BB&nbsp; &nbsp; &nbsp; B2<BR />B&nbsp; &nbsp; &nbsp; &nbsp; BC&nbsp; &nbsp; &nbsp; B3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022</P> <P>My output should be in stright table, If i apply filter L1 = A, Month = Jan and Year =2022 it should display as below. L1, L2 are my dimensions and Expression are Total_Dist_Count must be total distinct count of User_ID irrespective of selection <BR />and Dist_Count_month should not show count of Distinct User_ID according to month and year filter. If i apply filter L1=A, Month=Jan and Year=2022 the output table should show as below and it should not show L1=B values in it.</P> <P>Output table:<BR />L1&nbsp; &nbsp; &nbsp; L2&nbsp; &nbsp; &nbsp;Total_Dist_Count&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dist_count_month</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5<BR />A&nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<BR />A&nbsp; &nbsp; &nbsp; &nbsp; AB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<BR />A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P> Mon, 21 Mar 2022 10:36:49 GMT sharu055 2022-03-21T10:36:49Z https://community.qlik.com/t5/App-Development/Filters-not-working-in-Qlikview-stright-table-when-i-use-1-or/m-p/1907523#M74788 <P>Hi,<BR />Below my input columns and i mentioned required output as well. please help me in finding the output in Stright table.<BR />Input table:<BR />L1&nbsp; &nbsp; L2&nbsp; &nbsp; User_ID&nbsp; &nbsp; Month&nbsp; &nbsp; &nbsp;year<BR />A&nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; A1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; AB&nbsp; &nbsp; &nbsp;A2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan&nbsp; &nbsp; &nbsp; &nbsp;2022<BR />A&nbsp; &nbsp; &nbsp; AC&nbsp; &nbsp; &nbsp;A3</P> <P>A&nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp;A11<BR />A&nbsp; &nbsp; &nbsp; AB&nbsp; &nbsp; &nbsp;A21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; AC&nbsp; &nbsp; &nbsp;A31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; &nbsp;AA&nbsp; &nbsp; &nbsp;A4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />A&nbsp; &nbsp; &nbsp; &nbsp;AB&nbsp; &nbsp; &nbsp;A5<BR />A&nbsp; &nbsp; &nbsp; &nbsp; AC&nbsp; &nbsp; &nbsp;A6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />B&nbsp; &nbsp; &nbsp; &nbsp; BA&nbsp; &nbsp; &nbsp; B1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022<BR />B&nbsp; &nbsp; &nbsp; &nbsp; BB&nbsp; &nbsp; &nbsp; B2<BR />B&nbsp; &nbsp; &nbsp; &nbsp; BC&nbsp; &nbsp; &nbsp; B3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022</P> <P>My output should be in stright table, If i apply filter L1 = A, Month = Jan and Year =2022 it should display as below. L1, L2 are my dimensions and Expression are Total_Dist_Count must be total distinct count of User_ID irrespective of selection <BR />and Dist_Count_month should not show count of Distinct User_ID according to month and year filter. If i apply filter L1=A, Month=Jan and Year=2022 the output table should show as below and it should not show L1=B values in it.</P> <P>Output table:<BR />L1&nbsp; &nbsp; &nbsp; L2&nbsp; &nbsp; &nbsp;Total_Dist_Count&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dist_count_month</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5<BR />A&nbsp; &nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<BR />A&nbsp; &nbsp; &nbsp; &nbsp; AB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<BR />A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P> Mon, 21 Mar 2022 10:36:49 GMT https://community.qlik.com/t5/App-Development/Filters-not-working-in-Qlikview-stright-table-when-i-use-1-or/m-p/1907523#M74788 sharu055 2022-03-21T10:36:49Z