topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

HI Guys

i have data in attached excel

let say if i select Field , let say

1001

805115

than report should show rest of the rows and in total count 805115 , shud be excluded.

i m trying to do this like count({1-$}Material count)

but getting wrong result

swuehl — Tue, 29 Mar 2016 15:09:14 GMT

Do you want to sum or count the remaining rows?

=Sum({1-$} [Material count])

sunny_talwar — Tue, 29 Mar 2016 15:10:10 GMT

What are you getting and what do you expect to see?

abhaysingh — Tue, 29 Mar 2016 17:19:44 GMT

Hi,

does aggregation function really matters? in few conditions i want count and in few i want sum too

swuehl — Tue, 29 Mar 2016 17:22:56 GMT

Well, it might matter with regard to what you are expecting as a result, right?

So, as Sunny also asked for, could you describe what you get and what you expect to get?

abhaysingh — Tue, 29 Mar 2016 17:24:44 GMT

even after using below condition

count({1-$ < Flag = {'TXN'}>}MaterialCount)

My count value is getting increase as actual count, not able to understand why..

pls suggest