topic Re: Brushing and set analysis in QlikView

Brushing and set analysis

belromvar — Thu, 27 Sep 2018 08:27:29 GMT

Hi community,

I have the following scenario. I am trying to apply the brushing technique (highlight not filter) and came to following problem.

I have one diagram with Month as dimension(Chart1) and another one just below with Weeks als dimension (Chart 2). Both share the same expressions.

The problem comes because one Week can belong to 2 months.

In my calculation I want to display only the No. of Rounds related to the selected month (like in Chart 3) but still show all the weeks.

In the case above, Chart 2 should show 4 and 1.

Is this possible at all?

Thanks!

tresB — Thu, 27 Sep 2018 08:45:07 GMT

Try below expression:

=count(distinct RoundCounter)*avg({1}1)

belromvar — Thu, 27 Sep 2018 08:49:35 GMT

The calculation is right but it filters the "inactive" weeks out.

tresB — Thu, 27 Sep 2018 08:51:03 GMT

Uncheck 'Supress zero-values' in presentation tab.

belromvar — Thu, 27 Sep 2018 08:54:38 GMT

Still not right, it assigns 0´s to the other values and I would like to see them, just with a different color.

tresB — Thu, 27 Sep 2018 09:08:03 GMT

Well, then try this?

=If(Cal_Week=Cal_Week, count(distinct RoundCounter), Count({1}distinct RoundCounter))

Note: Now you need to check zero suppression setting.

belromvar — Thu, 27 Sep 2018 09:11:48 GMT

Thanks for your help. It works