topic Re: sum in QlikView

sum

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

iam trying to get the total for this expression.. but getting 0 values

Sum({<$(='[Invoice_T]')={'SPO'}>}$(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

i tried below but get 0 values

Sum({TOTAL<$(='[Invoice_T]')={'SPO'}>}$(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

sunny_talwar — Thu, 16 Feb 2017 14:21:37 GMT

Would you be able to share a sample?

raadwiptec — Thu, 16 Feb 2017 14:26:46 GMT

i do not have sample.. it s a very big file..

Sum({<$(='[Invoice_T]')={'SPO'}>}$(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']')) -this part works and iam using it sometimes..

now i need total

Anonymous — Thu, 16 Feb 2017 14:28:38 GMT

Are these fields are in different tables Expense Amount , Invoice Type , Rates ?

try this

Sum({<$([Invoice_T])={'SPO'}>} $(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

raadwiptec — Thu, 16 Feb 2017 14:32:16 GMT

hi allu wer is total here

Anonymous — Thu, 16 Feb 2017 14:48:19 GMT

so you want sum of Expense Amount , Invoice Type , Rates fields when Invoice_T = SPO ?

raadwiptec — Thu, 16 Feb 2017 14:56:02 GMT

i already have the sum but i need the full total now

Anonymous — Thu, 16 Feb 2017 15:07:53 GMT

I am not sure about this ,

Remove $

Sum({<([Invoice_T])={'SPO'}>} $(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

Sum( Total {<([Invoice_T])={'SPO'}>} $(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

I think you better work with aggr() functions for this