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

Filter Counts on Document Types

HI -

I am looking for a formula that will help me filter my chart by Type 1/2 dimensions.

In other words i wanted to display COUNT by location for Type 1/2.

Fields:

Dim1. Date

Dim2. Location

Dim3. Type. 1.Type 2. Type.3, Type.4,5,6........

Measure. Count

Is this possible? Please help.

Thank you,

1 Solution

Accepted Solutions
Not applicable
Author

Hi zvirina 123

Just for understand better your issue, you need  that your Chart only Display count of your Measure when the Measure is on type 1 and 2??

If yes, you can try this:

Count({<Type={1,2}>}Measure)

Let me know if it works!!

Greetings.

View solution in original post

8 Replies
Not applicable
Author

Hi zvirina 123

Just for understand better your issue, you need  that your Chart only Display count of your Measure when the Measure is on type 1 and 2??

If yes, you can try this:

Count({<Type={1,2}>}Measure)

Let me know if it works!!

Greetings.

Not applicable
Author

THANK YOU

Not applicable
Author

Another question. What if i need to do Sum(Distintct(.....the formula you gave does not work with sum.

Any other suggestions?


Thank you

MayilVahanan

HI

Try like this

Sum({<Type={1,2}>}Measure)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

what about distinct?

Not applicable
Author

Hi,

You can use it, you could try this:

Sum(Distinct {<Type={1,2}>} Measure)

Share us the results please

Not applicable
Author

I did and that does not work. Any other suggestions?


Thank you

Not applicable
Author

Can you attach you qvw, maybe I can help you more with an example

Greetings