Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kpatelacmm
Contributor
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
Master II
Master II

Please attach a small sample which demonstrates your problem.

that will make it much easier to assist

hope this helps

kpatelacmm
Contributor
Contributor
Author

Sure. File attached.