topic Re: How to filter out Project_No '9000098' from Project_Number in QlikView

How to filter out Project_No '9000098' from Project_Number

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I want to have all the Project Numbers except '9000098' from the Project_Number column.

How can I do that?

thanks

Re: How to filter out Project_No '9000098' from Project_Number

sunny_talwar — Wed, 10 Oct 2018 18:10:34 GMT

In the script or front end of the app?

Re: How to filter out Project_No '9000098' from Project_Number

bhaveshp90 — Wed, 10 Oct 2018 18:13:08 GMT

In the front end. I have this bar graph but I want to filter this project Number from it. I am not using Project_Number as dimension or Expression here;

Re: How to filter out Project_No '9000098' from Project_Number

sunny_talwar — Wed, 10 Oct 2018 18:14:59 GMT

You must have some expression? Let's say your expression is Sum(Measure)... use set analysis to exclude the specific project

Sum({<Project_Number -= {'9000098'}>}Measure)

Alternatively, you can also use this

Sum({<Project_Number *= e({<Project_Number = {'9000098'}>})>}Measure)

Re: How to filter out Project_No '9000098' from Project_Number

dplr-rn — Wed, 10 Oct 2018 18:15:27 GMT

Use this as part of your set analysis

Project_Number-={'9000098'}

Re: How to filter out Project_No '9000098' from Project_Number

jayanttibhe — Wed, 10 Oct 2018 18:16:47 GMT

in your Set expression you need to Exclude this Proje Num - 9000098.

You can share your expression for exact solution.

Re: How to filter out Project_No '9000098' from Project_Number

bhaveshp90 — Wed, 10 Oct 2018 18:29:46 GMT

When I used this expression. my chart is not displaying any data;

Sum({<Project_Number -= {'9000098'}>}((GMP_Gross_Profit_USD)/(GMP_Sales_USD)))*100

What am I doing wrong here?

Re: How to filter out Project_No '9000098' from Project_Number

bhaveshp90 — Wed, 10 Oct 2018 18:32:36 GMT

I used this expression now;

Sum({<Project_Number -= {'9000098'}>}((GMP_Gross_Profit_USD)/(GMP_Sales_USD)))*100

My chart is showing no data

Re: How to filter out Project_No '9000098' from Project_Number

sunny_talwar — Wed, 10 Oct 2018 18:39:48 GMT

Don't see anything wrong with the expression... would you be able to share a sample or an image to see the issue?

Re: How to filter out Project_No '9000098' from Project_Number

jayanttibhe — Wed, 10 Oct 2018 18:48:07 GMT

How abt this

(Sum({<Project_Number -= {'9000098'}>}GMP_Gross_Profit_USD)

Sum({<Project_Number -= {'9000098'}>}GMP_Sales_USD))*100

Re: How to filter out Project_No '9000098' from Project_Number

vishsaggi — Wed, 10 Oct 2018 18:49:43 GMT

= Sum(IF(Project_Number <> '9000098', Measure))

Re: How to filter out Project_No '9000098' from Project_Number

bhaveshp90 — Wed, 10 Oct 2018 18:54:40 GMT

Yes, It worked out. thank you

Re: How to filter out Project_No '9000098' from Project_Number

bhaveshp90 — Wed, 10 Oct 2018 18:56:19 GMT

thank you Sunny. I have used this expression and it worked out.

(Sum({<Project_Number -= {'9000098'}>}GMP_Gross_Profit_USD)

Sum({<Project_Number -= {'9000098'}>}GMP_Sales_USD))*100

Re: How to filter out Project_No '9000098' from Project_Number

sunny_talwar — Wed, 10 Oct 2018 18:59:22 GMT

Awesome