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.

[Anonymous]

Hi Shane,

It seem your primary requirement is to display all the rows that have CAR Action Close Date .

Even if Table C has null value for CAR Action Close Date but has matching CAR_CAR key this row should be displayed.

In case above is correct , then I suggest you to edit your load script and add a Inner Join on the Table C.

This will bring only rows where there is data (even null value)  for CAR Action Close Date .

Hope This helps.

Thanks.

[isingh30]

Please share your data or app.

Thank you!

[Qlik_ULG]

I cannot share the data, but it consists of ~80 columns, which I have converted into tables using cross tables.

here is my script.

[isingh30]

Try this  in your table -

only(${<CAR Action close date  = {'your dates'}>}Age)

Thank you!

[Qlik_ULG]

Hi Abhijit,

Thanks for your reply.

Which table do you suggest joining it to?

When I try to do Inner Join Table C to Table A, I get an error -  illegal combination of prefixes.

[Qlik_ULG]

Thank you for your reply Ishtdeep,

I get a calculation error when using that expression. Should the $ sign be included?

I have tried and if(match) expression but also get errors then.

[Anonymous]

Hi,

Before Performing Join operation, edit your cross table script and add a Load Statement to load the tables in separate QVD files.

After the QVD Files are ready then load them in your model. Perform the join operation while loading the QVDs.

You can do a Table C inner join Table D ; or Table C right outer join table D.

[isingh30]

$ sign is used for current selection in set analysis. You can remove that. I can do this for you but i need app or raw data for a better understanding.

[Qlik_ULG]

Hi Ishteep,

please find attached the data & app.

Thanks,

Shane