topic Re: Granularity of data, different Value SHowing in QlikView

Granularity of data, different Value SHowing

ivandrago — Thu, 12 May 2016 11:59:47 GMT

Hi,

I have the attached document, I want my text box to show a certain figure but due to the granularity of the data I am unable to get this.

Any ideas?

Thanks

swuehl — Thu, 12 May 2016 12:04:36 GMT

Could you describe a bit closer how you calculated

302930.76

alexandros17 — Thu, 12 May 2016 12:06:25 GMT

Use this value in your text box

='Value'&chr(10)&chr(10)&sum(Aggr(DISTINCT #UnallocatedAmount, %PK))

let me know

Clever_Anjos — Thu, 12 May 2016 12:10:02 GMT

Please try

='Value'&chr(10)&chr(10)&sum(aggr(only(#UnallocatedAmount),%PK))

sunny_talwar — Thu, 12 May 2016 12:34:46 GMT

My bad, I didn't realize this was already mentioned

swuehl — Thu, 12 May 2016 12:52:49 GMT

Maybe another option without the need for advanced aggregation:

=Rangesum(

Sum(#LineValue),

Sum( {<Product = {'NOT APPLICABLE'}>} #UnallocatedAmount)

)