Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fortaleza40
Contributor III
Contributor III

Master calendar with Pivot table show additional row empty

I need a particular structure for a report using master calendar, like this:

 1/1/20151/2/20151/3/20151/4/20151/5/20151/6/20151/7/20151/8/2015
Client Counts52420367

 

So i created a Master Calendar linked with my client table using a common date field, also i create a field using this 'Client Count' AS [Client Count], to have all in one row, but i am getting an additional row with an empty field name and showing ceros and null, i want to have all in a single column, not sure why is doing this:

 1/1/20151/2/20151/3/20151/4/20151/5/20151/6/20151/7/20151/8/2015
-0--00   
Client Counts-24--367

 

Measure formula is this:

=Count({$<[Register Date]={"<=$(=EndDTVariable)"},[Register Date]={">=$(=StartDTVariable)"}>}Distinct([Client ID]))

2 Replies
petter
Partner - Champion III
Partner - Champion III

You should probably leave out the field that you created ... as you are doing it double... The expression should suffice. Just make sure that you have the expression/measure as a row and not a column.

fortaleza40
Contributor III
Contributor III
Author

The solution was use the month and year to create a month/year field, and use this new field to filter, that worked fine.