Hiding certain rows in a straight table

[Qlik_ULG]

Hi,

I have a straight table, that is built using 5 cross tables. They are linked using 1 PK, but it is not unique for each row as a result of coming from cross tables.

I have built a straight table, but it shows the rows as including NULL values, but also showing all available possible rows.

so to 'workaround' this, I suppress null values in the dimension limits setting, and the correct rows are then displayed, with unique values showing in the correct dimensions and rows.

Now as you can see here, there are 'double' rows for each of the Owner1, Owner2, Owner3 - this is incorrect. It should only be taking in the rows that have have a CAR Action Close Date. For Owner4, it is correct as that is actually null in the data.

Is there a way to only include certain rows - in this case it would be the first (or top) row.

Thanks in advance.

[isingh30]

Try like this in your expression -

only({<ActionCloseDate  = {'3/8/2017'}>}ActionOwner)

Thank you!

[Qlik_ULG]

Hi Ishtdeep,

This again shows an error for me. Are you including this as an expression?

Also, I want to be able to see the date that is appropriate, not hard code in dates as there will be dates in the future. It should show the appropriate CAR CloseDate for the CAR Action ID, Owner & Date Initiated.

[Qlik_ULG]

Hi Ishtdeep, when I include the following expression, the correct data is shown,

only({<ActionCloseDate  = {'Date action closed - 1'},ActionOwner= {'Owner - 1'},ActionOpenDate= {'Date action initiated - 1'},ActionCloseDate= {'Date action closed - 1'}>}date(CloseDate))

But it only shows for the correct row - which is correct. I now have to include this for all rows, not just row 1.

Is there a way of including multiple ONLY statements in the one expression?

Thanks.

[isingh30]

Try - 'Owner *' . Let me know.

Thanks.

[Qlik_ULG]

No, I still get a NULL value for all rows when I include 'Owner - *'

If I include, 'Owner - 1; or 'Owner -2' etc, the correct data shows in the correct row. I need to find a way of combining all these together,

Thanks.

[Qlik_ULG]

Hi Abhijit,

Thanks for the reply,

I have saved to QVDs and loaded a new QVW.

When I perform this join, I still get the same error. The dates are not linked still. Am I performing the join incorrectly?

but the data does not show up. If I supress null values to get rid of the duplicates, it does not show the correct NULL values.

[isingh30]

Try this in expression - 'Owner - 1 ,Owner -2,Owner -3'

'Owner - *' is incorrect please try this - 'Owner *' . * is a wildcard character it picks everything starts with 'Owner'.

[Qlik_ULG]

Hi Ishtdeep.

Neither of these work again. Including 'Owner *' will not work as it is still inside the '' so it will assume that this is the exact text needed.

Are you saying to include these as an expression or calculate dimension?

I need to include multiple ONLY statements. They work singularly and changing the = parenthesis is not doing anything.

[isingh30]

This is not dimesion it's expression. Try this in expression.