Filters not working in Qlikview stright table when i use 1 or Total in set expression. Below is my table and required output.
Hi, Below my input columns and i mentioned required output as well. please help me in finding the output in Stright table. Input table: L1 L2 User_ID Month year A AA A1 Jan 2022 A AB A2 Jan 2022 A AC A3
A AA A11 A AB A21 Jan 2022 A AC A31 Jan 2022 A AA A4 Jan 2022 A AB A5 A AC A6 Feb 2022 B BA B1 Jan 2022 B BB B2 B BC B3 Jan 2022
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 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.