Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER 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

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

View solution in original 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