topic Re: Show only values that accumulate to in QlikView

Show only values that accumulate to

slaheddinekeyru — Mon, 15 Jan 2018 16:12:03 GMT

Hi community,

I don't know how to describe my problem but it's very simple. I want to transform the straight table bellow into a Pie Chart while showing only values J,I,H,G,F,E that cumulates 80% of the total. My goal is to show biggest values that cumulate 80% of total expression.

You can find example in attachement.

Thank you very much for all your answers

Re: Show only values that accumulate to

el_aprendiz111 — Mon, 15 Jan 2018 16:27:52 GMT

Hi,

Re: Show only values that accumulate to

slaheddinekeyru — Mon, 15 Jan 2018 16:52:37 GMT

Thank you Fer Fer for your answer.

I was affraid that the problem is due to my Qlik Version.

I tried exactly what you did but it doesn't solve my problem.

Can you tell me please what version of QlikView you are using ?

I'm using this one : 12.10.20600.0 SR8

Re: Show only values that accumulate to

el_aprendiz111 — Mon, 15 Jan 2018 17:06:49 GMT

Version 11.20.12235,0

Re: Show only values that accumulate to

uacg0009 — Tue, 16 Jan 2018 08:55:45 GMT

Hi Slaheddine,

I didn't check other threads, but I think Fer Fer's answer is correct, and It maybe a bug for Qlikview 12.

I check it in Qlikview11 and 12.

Same setting, different answer.

Thanks.

Aiolos

Re: Show only values that accumulate to

sunny_talwar — Tue, 16 Jan 2018 09:35:02 GMT

You might be able to try this... but this excludes E because E is greater than 80%...

Sum({<DIM = {"=Aggr(RangeSum(Above(Sum(FACT), 0, RowNo())), (DIM, (=Sum(FACT), DESC)))/Sum(TOTAL FACT) <= 0.80"}>}FACT)

Re: Show only values that accumulate to

slaheddinekeyru — Tue, 16 Jan 2018 13:19:58 GMT

Thank you Aiolos for trying it.

We can confirm it's a bug of Qlik 12.

Re: Show only values that accumulate to

slaheddinekeyru — Tue, 16 Jan 2018 15:24:31 GMT

Thank you Sunny for your Answer,

But this way we can't show the "Others" Values

Re: Show only values that accumulate to

sunny_talwar — Tue, 16 Jan 2018 15:31:19 GMT

Like this

Re: Show only values that accumulate to

slaheddinekeyru — Thu, 18 Jan 2018 10:43:29 GMT

Good shot ! Thanks a lot !

But I think QlikTech must fix this issu