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: 
Not applicable

Create Chart expression that ignores the dimension

Hi all,

I have a graph with the following structure:

Dimension - Hour

Expression - Count(distinct SalesDate)

The problem is the following: In my chart, I get in each Hour the number of distinct days that a sale occured in the appropriate hour.

My goal is: to get the total number of days according to the filter. If I filter 12/07/14 and 11/07/14 I want to Expression in the chart to be 2 in every one of the hours ignoring wether or not a sale occured in that hour.

Can anyone help me?

My failed attempts: count(total distinct(SalesDate)) -failed because filtering one specific dates will not change this count

                             count(distinct {<Hour=>} SalesDate) - failes becuse the values are the same as in Count(distinct SalesDate).

Thanks!!!!

1 Reply
swuehl
MVP
MVP

As far as I understand,

=Count(TOTAL DISTINCT SalesDate)

should work. Not sure why it does not in your setting. Does it work as an expression in a text box (where you can remove the TOTAL again)?

Then you can also create a variable vCountDalesDates in variable overview

=Count(DISTINCT SalesDate)

and reference the variable in your chart expression.