Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
KharansuESSPL
Contributor II
Contributor II

Date range (derived) filter not working on line chart

Hi ,

I have a situation where I have created date range using a derived column called [Days Open] = 

$(Today)-Date(Created date) as [Days Open] and then this is used to create the ranges as '0-30', '31-60', '61-365' and '>365'.
But while creating different lines for different date ranges and filtering them accordingly - like selecting only '31-60' or only '>365' doesn't give me single line - gives me all of them. What can be done?
 
Created date can be the dimension.
 
required calculations -
If(IsNull([Days Open]), null(),
    If([Days Open]<31, '0-30',
    If([Days Open]>=31 and [Days Open]<61, '31-60',
    If([Days Open]>=61 and [Days Open]<365, '61-365',
    If([Days Open]>365,'>365'))))) as [Range]
 
For individual lines, I have created different measures like - 
Measure1 - Count({<[Range]={'31-60'}>}[Root cause])
Measure2 - Count({<[Range]={'61-365'}>}[Root cause])
Measure3 - Count({<[Range]={'>365'}>}[Root cause])
 
attached a sample excel
 
Thanks
1 Reply
Sue_Macaluso
Community Manager
Community Manager

@KharansuESSPL Your post has been released. 

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!