Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lukasrocek21
New Contributor III

Log of counts day by day

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

qlik.PNG

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

Tags (4)
7 Replies
vinieme12
Esteemed Contributor II

Re: Log of counts day by day

brunobertels
Valued Contributor

Re: Log of counts day by day

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())

)

lukasrocek21
New Contributor III

Re: Log of counts day by day

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
Esteemed Contributor II

Re: Log of counts day by day

rangesum(

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

)

lukasrocek21
New Contributor III

Re: Log of counts day by day

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

brunobertels
Valued Contributor

Re: Log of counts day by day

try with below :

rangesum(

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

)

lukasrocek21
New Contributor III

Re: Log of counts day by day

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