Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Please attach a small sample which demonstrates your problem.
that will make it much easier to assist
hope this helps
Sure. File attached.