Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kpatelacmm
New Contributor

Sum based on value between a range

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..

2 Replies
Frank_Hartmann
Honored Contributor

Re: Sum based on value between a range

Please attach a small sample which demonstrates your problem.

that will make it much easier to assist

hope this helps

kpatelacmm
New Contributor

Re: Sum based on value between a range

Sure. File attached.