how to build layout

[Manni_SM]

Hi @Lech_Miszkiewicz  , Ruggero_Piccoli

i want to build below layout in Qlik Sense and n printing could you please suggest how to achieve this?  both excel and pixel 

other question: if i want to create excel template and export as pdf means what are the changes i need to do. as i have a table with more than 20 fields in pdf 

[Lech_Miszkiewicz]

Hi @Manni_SM 

There are many ways this can be achieved. It is important to understand whole layout. On your screenshot you are showing rows of data for (....1A) and rows of data  for(....2A). Are those part of the same (one) record or are those already 2 different records?

NPrinting reports are based on structure (frame) we want to build to have then repetitive behaviour. If there is known list of attributes (address, city, state , tax ident etc... ) all those normally would have to be prepared in UI object. Then there is a question: do all entities have the same attributes and number of attributes? Different approach can be used for each of those scenarios

Depending on how your data is structured you may introduce "Entity-Attribute-Value" (EAV) model for this section as it looks like you need to cycle through entities and return set of attributes (row by row for that entity).

If number of attributes is constant you can just introduce Level to the table which will cycle through all available values for the level and you can have placeholder for each attribute with =Only(AttributeX) function returning each of them. Simple as that. 

Obviously best if all that information would be in single Qlik Sense Straight table object. The approach can be similar for excel and pixel perfect templates but excel will be easier to build

Bottom line is - for me to give you exact step by step instructions I would need to understand how you have your data in Qlik Sense and how you need your report to be produced. (so far I saw what i assume is just a portion of that) as surely your report will have more than 1 or 2 records? What should be shown when you clear selection in Qlik? Should you have 1 table with all records in that layout? Or on the other hand do you want users to pick/select single entity and then you have attributes shown for that entity as per your screenshot? Which one is it?

Your second question - PDF from excel is just a Print from excel so you need to set in excel template how you want your excel to be printed! Page Layout, Margins, Header, Footer etc)

cheers