Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mcarotenuto
Contributor II
Contributor II

Chart filter

Hello, i need to create a simple chart with y= month and as value i need to have the count(serial) only where the TAT_RANGE is ='IN' how can i do it? 

the fields used are:

y=Month

x=count(serialL3) where TAT_RANGE='IN'/count(serialL3)

tat_Range is a dimension with result YES/NO

thanks massimiliano

 

Labels (2)
1 Solution

Accepted Solutions
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Massimiliano,

 

You are looking for a so called Set Expression.

If your exact field name is [serialL3], then your expression needs to look like this:

 

count({<TAT_RANGE={'IN'}>} serialL3)

 

 

I hope that helps!


Kind regards,

S.T.

View solution in original post

2 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Massimiliano,

 

You are looking for a so called Set Expression.

If your exact field name is [serialL3], then your expression needs to look like this:

 

count({<TAT_RANGE={'IN'}>} serialL3)

 

 

I hope that helps!


Kind regards,

S.T.

mcarotenuto
Contributor II
Contributor II
Author

Perfect, now is clear thank you