Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Add condition

Hi...I'd like to add a condition to a straight table report to exclude data for certain types of journal category but I am not sure how to do this in the expression.

The exclusion condition I need is

(GLSubLedg.JournalCategory) <> 'Budget' AND (GLSubLedg.JournalCategory) <> 'Payments'

I would really appreciate some assistance with this.  Thanks

23 Replies
Highlighted
Contributor III
Contributor III

Hi...I get data but it also includes lines with the release date.  Please see screenshots

ReleaseDateExpression.jpgReleaseDateExpression2.jpg

Highlighted
Contributor III
Contributor III

Any other suggestions?

Highlighted

It's rather difficult to make guesses from screenshots. Can you post an example document that exhibits this behavior? You can scramble any company data that you don't want to leak on the internet.

The reason for this is probably something with how your set analysis selection is not specific enough to filter out all lines that you don't want to see. And this is highly dependent on your data model, the tables in which the two fields are stored and how those tables are connected. If you cannot upload an example document, try to figure out why exactly QlikView still shows those lines if you make a similar selection in your head.

Highlighted
Contributor III
Contributor III

I am using two tables on the report.  One is APINV which has the invoice details and the other one is APHOLDS which has the hold details.  I am using 4 fields from the APHOLDS table on the report.  There is a join between the two tables.

What I have noticed is that where the release date is null then then the other 3 fields from the APHOLDS table are null as well but I would expect data in those fields but where the release date field is not null the other 3 fields are populated with data as well.