Nprinting report from scratch

[ali_hijazi]

Hello
got 3 dimensions in my Qlik sense app:
Month, currency, scenario
I want to create the follwing simple report:

MONTH        CURRENCY        SCENARIO
202601          EUR                    ACTUAL
202601          USD                    ACTUAL
202601          EUR                    BUDGET
202601          USD                    BUDGET

202602          EUR                    ACTUAL
202602          USD                    ACTUAL
202602          EUR                    BUDGET
202602          USD                    BUDGET
...

I create 3 levels in Nprinting report editor as follows:

Now I want to use these in the excel sheet:
which I used as follows:

and the result is not as expected:

kindly advise on how to put the levels on the excel template
@Lech_Miszkiewicz 

[Andrea_Bertazzo]

hI @ali_hijazi,

I would not use levels in this case. I think the easiest option is to create a straight table in you Sense/QlikView app and import it directly in the template.
Is there any specific reason you prefer to work with levels?
Here you can find more references about Excel Reports.

[Vishal__Gupta]

@ali_hijazi did you try importing the table as simple straight table in excel and then creating a pivot table? Seems like that would solve your problem.

[ali_hijazi]

Hello @Andrea_Bertazzo , @Vishal__Gupta 
we need to create the table from scratch in Nprinting
we don't want to add more sheets / tables to the Qlik sense app

[robert_mika]

What is the expected result?

Try to add the 'deleterow' option to the row you do not want to print

[Lech_Miszkiewicz]

Hi @ali_hijazi 

I dont understand your output requirement. Why do you need to use levels if your suggested output looks like straight table:

Just create it as a straight table in Qlik Sense and bring it through as a straight table columns (not levels). 

If you want additional formatting you may add columns to your straight table which will bring through formats you would need to apply to rows - simple as that. 

At the moment I think you are overcomplicating things with levels, but maybe we don't know something about the requirement you have which you have not mentioned yet. Based on current information - just use straight table and thats it.

cheers

Lech

[Ruggero_Piccoli]

Hi,

I agree with previous answers: the best way is to create a straight table in the source app and use it in the template. It is also much faster than using levels in reports generation. Using levels also results in not aligned rows. 

Best Regards,

Ruggero