data formating

[NavinReddy]

Hello All,

Could someone help me, how could i format the excel data like below image format. kindly help me i would like to format attached excel data below image format.

Regards,

Navin

[NavinReddy]

@Frank_Hartmann  kidnly help me

[Frank_Hartmann]

for me its still not clear which field you want to use as header.

can u share a screenshot (maybe excel) with expected  result (just for the first lines/IDs..) based on the QV table you provided?

[NavinReddy]

@Frank_Hartmann Good Morning

i would like to display IDs based on Function. Function header and related IDs . sorry for my bad explanation. 

[Frank_Hartmann · Accepted solution]

see attached qvw

hope this helps

[NavinReddy]

@Frank_Hartmann  wow that was awesome answe,

please suggest me if want to add any other field to the same list how can i add. thanks a lot for your help

[Frank_Hartmann]

which further field/s do you need  in the table?

the thing is that you need to make the fieldelements invisible  depending on if the line element is an header or an id. therefore have a look at the dim expressions (and its background and text color expressions.) For the new field you just need to adapt the background color expression and the text Color expression....

[NavinReddy]

Thank you so much for your help.

i got struck with one issue i have created report using report editor, now i can see one field for one page now i have 100 fields its printing 100 pages, pelase help me how could i arragne with fields based on size on pdf page. kindly help me.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Removing-extra-space-between-fields-in-...