Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
brettaustin
New Contributor III

Straight Table with Expression Not displaying all Data

I created a straight table with an expression to 'filter' the data.  When I remove one of the columns, one of the records disappears!?   What is going on here!  See attached for example

Please help!

1 Solution

Accepted Solutions

Re: Straight Table with Expression Not displaying all Data

Try using set analysis instead of if statement

Only({<Status = {'5. Validation'}, [Current State] = {'Y'}>} Status)


Capture.PNG

View solution in original post

2 Replies

Re: Straight Table with Expression Not displaying all Data

Try using set analysis instead of if statement

Only({<Status = {'5. Validation'}, [Current State] = {'Y'}>} Status)


Capture.PNG

View solution in original post

brettaustin
New Contributor III

Re: Straight Table with Expression Not displaying all Data

Works GREAT!  Thank you Sunny!