Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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: 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 |
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Visualizations/time-aware-charts.htm
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())
)
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...
rangesum(
above(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())
)
It is better, but I have sorting by date descending, so I need reverse it...
try with below :
rangesum(
below(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())
)
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...