topic Re: Show certain row based on input value in QlikView

Show certain row based on input value

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

I have a table looking like this:

I want to only show the row where column "Accumulated %" is the same as the value in TargetCoverage, in this case 95%.

My current expression in "Accumulated %" looks like this:

rangesum(above(total sum(DSP_ORD_VOL2)/Sum(TOTAL <[Supplier No]>(DSP_ORD_VOL2)),0,Key))

Anil_Babu_Samineni — Fri, 13 Oct 2017 09:15:55 GMT

May be this?

If(

rangesum(above(total sum(DSP_ORD_VOL2)/Sum(TOTAL <[Supplier No]>(DSP_ORD_VOL2)),0,Key)) = $(TargetCoverage),

rangesum(above(total sum(DSP_ORD_VOL2)/Sum(TOTAL <[Supplier No]>(DSP_ORD_VOL2)),0,Key)))

damirm86 — Fri, 13 Oct 2017 09:23:16 GMT

I have already tried that one without result unfortunately...