topic Create a top row in table in QlikView

Create a top row in table

Anonymous — Fri, 17 Jul 2015 08:42:33 GMT

Hi guys,

Bit of a long shot with this one. I have a table which I would like to always have a row which appears at the top. My table currently looks like this

I would like to add a top row like this (the row highlighted in bold)

Does anyone know if this is possible at all?

Thanks

Jamel

Re: Create a top row in table

datanibbler — Fri, 17 Jul 2015 08:44:56 GMT

Hi,

could you be a bit more specific about what you want to do? Do you mean that one (existing) row in the table should always be on top, irrespective of sorting, or do you want to create a completely new header_row to show above the rest of the table?

Best regards,

DataNibbler

Re: Create a top row in table

alexandros17 — Fri, 17 Jul 2015 08:48:32 GMT

Yes, it is possible,

suppose you have:

Load special, product_code ....

Resident ....

Then simply

after that use:

Concatenate

Load Distinct special resident ... (the same table as before)

there are only 2 problems remaining:

The rows that you have added, having all values equal to o will no apper until you uncheck the box "Suppress zero values" in presentation tab.

The second problem is the sorting, to let appare the row in the first position

Re: Create a top row in table

Anonymous — Fri, 17 Jul 2015 08:50:01 GMT

Hi,

Thanks for response.

I would always like just the one row to appear like the above screenshot in my table on the top irrespective of sorting. I guess I could sort by price any way as the price is always set to zero in the row I would like to create. I realise this is a tricky one so wasn't sure if this was possible to do.

Re: Create a top row in table

Anonymous — Fri, 17 Jul 2015 09:37:37 GMT

Thanks for your help.

I have tried to concatenate the load but it is creating an extra row per product (screenshot below)

Sooooo close!

Re: Create a top row in table

alexandros17 — Fri, 17 Jul 2015 09:42:03 GMT

If you need your row only for one value of special write:

concatenate

Load Distinct special resident ... (the same table as before) where special ='71J'

Re: Create a top row in table

Anonymous — Fri, 17 Jul 2015 09:47:00 GMT

Unfortunately that won't work as the special is always different...

If this is a not possible I will give up on this idea. Would have been nice to get working though