Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
belromvar
Contributor II
Contributor II

Brushing and set analysis

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.

Capture.PNG

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

Is this possible at all?

Thanks!

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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.

View solution in original post

6 Replies
tresesco
MVP
MVP

Try below expression:

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

belromvar
Contributor II
Contributor II
Author

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

tresesco
MVP
MVP

Uncheck 'Supress zero-values' in presentation tab.

belromvar
Contributor II
Contributor II
Author

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

tresesco
MVP
MVP

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
Contributor II
Contributor II
Author

Thanks for your help. It works