counting issue

[#1]

Hello,

I have an incremental dbase and i wanna use the total role count on calculation, but when i make a selection on any option the total role count gives me 1 which is the normal QlikView process. What do I do to get the total count and selection wont affect it so i get the exact value i want.

Ema

[Anil_Babu_Samineni]

I just assume you may add TOTAL

Count({<Dim1={}, Dim2={}, Dim3={}>} TOTAL Sales)

[#3]

didnt work, when i make a selection the number changed

[Anil_Babu_Samineni · Accepted solution]

If you don't want to change number you may use 1 for fixed of that object by using sample this

Count({1<Dim1={}, Dim2={}, Dim3={}>} TOTAL Sales)