Qlik Community

New to Qlik Sense

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

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenhasson
Creator
Creator

Exclude certain records in a chart?

Hi,

I have a bar chart  which has an expression  "sum(ReceivedToStockQty)/Sum(ProdQty)" to show the percentage of stock received vs expected.

It works fine, but i'd like to remove anything where the percentage is 100% (or ratio is 1 I guess), but can't figure out the syntax in set analysis / if statement to achieve this.

Thanks.

1 Solution

Accepted Solutions
stephenhasson
Creator
Creator
Author

That works perfectly........... thank you very much. I really need to get my head round this syntax.

View solution in original post

6 Replies
OmarBenSalem
Partner
Partner

maybe :

if( sum({1}ReceivedToStockQty)/Sum({1}ProdQty)=1,0,sum(ReceivedToStockQty)/Sum(ProdQty))


and under adds on, uncheck show zero values

stephenhasson
Creator
Creator
Author

That works perfectly........... thank you very much. I really need to get my head round this syntax.

pablolabbe
Luminary Alumni
Luminary Alumni

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

OmarBenSalem
Partner
Partner

Great !

Than please close the thread by marking the CORRECT answer as CORRECT.

zebhashmi
Specialist
Specialist

Try E()

OmarBenSalem
Partner
Partner

Can u just explain how was this answer helpful AND correct ?

Capture.PNG