Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sharu055
Creator
Creator

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