Create Chart expression that ignores the dimension

Sat, 12 Jul 2014 11:39:41 GMT

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!!!!

Re: Create Chart expression that ignores the dimension

swuehl — Sat, 12 Jul 2014 11:51:14 GMT

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.

topic Re: Create Chart expression that ignores the dimension in QlikView

Create Chart expression that ignores the dimension

Re: Create Chart expression that ignores the dimension