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: 
HereWeGoAgain
Contributor III
Contributor III

How to display certain data based on a criteria without using a Filter

Good Day

Please assist:

 

I would like to create a bar chart based on a certain criteria without using a "filter pane".

eg. Names column, I only want the revenue/loads/sales that "Sam" did and not the others.

 

Thanks in Advance

1 Solution

Accepted Solutions
MayilVahanan

HI @HereWeGoAgain 

You can use set analysis, for ex:

Sum({<Names={'Sam'}>}Revenue)

-- above exp gives sam revenue alone.

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

View solution in original post

3 Replies
MayilVahanan

HI @HereWeGoAgain 

You can use set analysis, for ex:

Sum({<Names={'Sam'}>}Revenue)

-- above exp gives sam revenue alone.

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

Thanks @MayilVahanan 

with the same example, how will i exclude a certain name and display Revenue for all others?

 

Thanks in advance

MayilVahanan

Hi @HereWeGoAgain 

If you want to exclude certain names, try like this

Sum({<Names-={'Sam', 'Mayil', 'Ram'}>}Revenue)

-- above will exclude Sam, Mayil & Ram revenue.

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