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: 
Not applicable

Exclude Sales Orders based on Cost Category

My data in QVD looks like below:

Sales Order    Cost Category     Values

1000               A                        100    

1000               B                        200

1000               C                        300

1000               D                        400   

2000               A                        100    

2000               B                        200

2000               C                        300

      

If the Sales Order has Cost Category D then my report should not show Sales Order 1000. My report output should only show data for sales order 2000.

I tried following calculated dimension with following syntax but its not working:

= if(Cost Category = 'D', null(),Sales Order)

Any help is appreciated.

10 Replies
Not applicable
Author

Hi,

see this example.

You now able to select the values you need.

Good Luck!

Rainer