I have a calculation that has created a value (count of items) this is in a chart which shows monthly buckets this is based on when the item expires.
Expression is
Count(distinct {$<EVENTCODE={'ITEM'},EXPDATE = {'<=$(vTHISMNTHEND)'}>} ITEMID)
Dimension is
Eventmonth year.
I am trying to get For each month how many items that have expired.
ie JAN 270 Feb 214 Mar 203.
My result shows each month with the previous months count in it aswell.
ie Jan 2042 the result I want is Jan 270 which is jan 2042 -1772
Feb 1772 Feb 214 feb 1772 - 1558
Mar 1558 Mar 203 mar 1558 -1355 (Apr)
etc.
I am very new to Qlik and would appreciate any assistance .
Regards Graham
