Sum based on value between a range

kpatelacmm — Tue, 02 May 2017 19:19:34 GMT

I am trying to have Qlikview dynamically look up a value based on a specific result and where it matches sum up all the matches. See my expression below. However I keep getting 9999 as the answer.

=if(floor((count({<YEAR=,COMDueString={'Not Due'}>}COMDueString)/
count({<YEAR=>}COMDueString)*100))=COMRange1,'1234','9999')

My dimension is connected to another table that has the ranges like below. If this

floor((count({<YEAR=,COMDueString={'Not Due'}>}COMDueString)/
count({<YEAR=>}COMDueString)*100))

is between 0 to 10 then I want to sum everything that matches in the same way. So if there was only one record I would get 1 as my answer.

0 to 10 = 1

11 to 20 = 2

etc..

Re: Sum based on value between a range

Frank_Hartmann — Tue, 02 May 2017 19:28:05 GMT

Please attach a small sample which demonstrates your problem.

that will make it much easier to assist

hope this helps

Re: Sum based on value between a range

kpatelacmm — Tue, 02 May 2017 21:03:29 GMT

Sure. File attached.

topic Re: Sum based on value between a range in QlikView

Sum based on value between a range

Re: Sum based on value between a range

Re: Sum based on value between a range