Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.