Filters not working when i use 1 or Total in my Qlikview stright table set expression

[sharu055]

Hi,

I using stright table in qlikview with two dimension and 5 expression. In one expression i need to count all the user ID. I use Count({1} Distinct(User ID)). Its works perfectly for all the dimension. But if i apply filter for perticular dimension the stright table wont filter, insted of that it will show 0 values for other records and show exact records for filter value. But All the records irrespective of selection is present in the stright table. I need tatal count of selected values in stright table only for current selection.

Please help me in resolving

[sharu055]

Yes, you are right. I want one column total User ID for L1=A irrespective of selection. Please help me with that, thats what i needed in my table. 

[sharu055]

Hi,

Is it possible to create a column of total count of User ID with irrespective of selection and with filtering other columns.

[Digvijay_Singh]

I am still not sure whats the exact need, the image I shared earlier, don't you need the last column where results are matching as you desired and it would disregard selections on fields as mentioned in the set expression i.e. month=, year=, you can add more fields like that.

[sharu055]

Actually it wont work if the month and year = null. I need one column with total of User ID irrespective of selection. If i use Total function or 1 in the set analysis other filters not work for the stright table it shows other dimension values if i select L1=A.

[Digvijay_Singh · Accepted solution]

I don't see other dimension values than L1='A', I mean I don't see L1='B' in the bottom table

[sharu055]

Hi Digvijay,

I wonder its working in Qliksense, but same not working for me in Qlikview. If i Select the L1=A and Month=Jan, year=2022 i wont get the last column as it displayed in your screen shot. I use Count ({1 } DISTINCT [Standard Id]) then i will get that column but with that L2 values also dispalys in stright table.

[sharu055]

Thank you so much, its working.