Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brandon_d
Contributor III
Contributor III

How do I ignore the column dimension in my expression?

I am trying to pull together a table of averages across different hours of the day. However, I am having a problem with getting the denominator to calculate properly. In the attached example, I would want the denominator for each of these boxes to be 30 because that is how many days of business we had during the selected time period. 

The current formula to get the values shown in the attached image is as follows:

Count(distinct([Appt Date]))

Unfortunately, this is only counting if there is an appointment date for the given time in the table. 

 
 
 
1 Solution

Accepted Solutions
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Brandon,

 

Can you try this:

Count(TOTAL distinct([Appt Date]))

 It depends a bit on your model and chart structure if this will work or not. Worst case we need to go for an aggr() but let's see if the above will do the trick.

 

Please let me know if that helps!

 

Kind regards,

S.T.

View solution in original post

1 Reply
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Brandon,

 

Can you try this:

Count(TOTAL distinct([Appt Date]))

 It depends a bit on your model and chart structure if this will work or not. Worst case we need to go for an aggr() but let's see if the above will do the trick.

 

Please let me know if that helps!

 

Kind regards,

S.T.