Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
I just assume you may add TOTAL
Count({<Dim1={}, Dim2={}, Dim3={}>} TOTAL Sales)
didnt work, when i make a selection the number changed
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)