Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Trend Chart Using Date Range in a Set Analysis Expression

I am trying to create a trend line chart with CalendarDate as the dimension and a COUNT of Active Properties as the expression.

I had to use a set analysis expression in order to COUNT the number of active properties on a given day:

=COUNT({<BegDateOfOperation = {'<=$(=CalendarDate)'}, EndDateOfOperation = {'>$(=CalendarDate)'}>}  %PropertyKey)


The problem is that all I get is either a straight line or a "No data to display" message when I try to create the chart. Attached is a screenshot. I would highly appreciate some advice.


Trend Capture.PNG

1 Solution

Accepted Solutions
Highlighted
Champion II
Champion II

You need a RowKey that identifies each row uniquely for such intra record calculations or use IF()

Count(IF( BegDateOfOperation <= $(=CalendarDate) and EndDateOfOperation > $(=CalendarDate) , %PropertyKey))

OR

=COUNT({<RowKEY = {"=BegDateOfOperation <=$(CalendarDate) and  EndDateOfOperation >$(CalendarDate)"} >}  %PropertyKey)


Read this Post


set_analysis_intra-record.qvw




View solution in original post

3 Replies
Highlighted

try to use only aggregation function

=COUNT(%PropertyKey)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist
Specialist

Will you be able to share a sample qvw??

Highlighted
Champion II
Champion II

You need a RowKey that identifies each row uniquely for such intra record calculations or use IF()

Count(IF( BegDateOfOperation <= $(=CalendarDate) and EndDateOfOperation > $(=CalendarDate) , %PropertyKey))

OR

=COUNT({<RowKEY = {"=BegDateOfOperation <=$(CalendarDate) and  EndDateOfOperation >$(CalendarDate)"} >}  %PropertyKey)


Read this Post


set_analysis_intra-record.qvw




View solution in original post