Log of counts day by day

[Anonymous]

I have table with 3 important atributes: CT[string], DATE[yyyy-mm-dd] and OpenClosed[OPEN,CLOSED]. I have combo chart (on X axis is Date {2016-6-12} day by day) with two values: Count( {< OpenClosed = {'CLOSED'} >}Distinct CT)and Count( {< OpenClosed = {'OPEN'} >}Distinct CT) for open and closed CTs. I need add line chart to this combo chart with count of Open CTs day by day. For example: 4th December 2200 CTs, 5th December 2310 CTs, 6th December 2250 CTs.....

KPI TOTAL OPEN CT is value for last day (last reload) solved by Count( {< OpenClosed = {'OPEN'} >}Distinct CT). It is count of ALL open items in table. So I need view this value for each day in combo chart as line...

Is it possible, or I must do some special table in Excel in this case? Thanks for your answers

[vinieme12]

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Visualizations/time-aware-charts.htm

[brunobertels]

Hi

Not sure to well understand your requierment, but if you want to know day by day your stock of Open CT

try this for line chart

rangesum(

above(

Count( {< OpenClosed = {'OPEN'} >}Distinct CT)

)

)

my mistake the right formula is

rangesum(

above(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())

)

[Anonymous]

I need sum of count for each day...count for first day is 30, for second 20, but i would like to see 50 (30+20) for second day...etc...

[vinieme12]

rangesum(

above(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())

)

[Anonymous]

It is better, but I have sorting by date descending, so I need reverse it...

[brunobertels]

try with below :

rangesum(

below(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())

)

[Anonymous]

Neither ABOVE, neither BELOW, but BELOW has better numbers, I think. BUT: On start of chart it looks good, to middle of chart. Then line falls down to zero... It looks like some Gauss line...