Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
sharu055
Contributor III
Contributor III

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.

Output table:
L1      L2     Total_Dist_Count         Dist_count_month

                               9                                                5
A        AA               3                                                 2
A        AB               3                                                 2
A         AC              3                                                 1

Labels (4)
0 Replies