Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
kevinchevrier
Partner - Creator III
Partner - Creator III

Word - Levels vertical ==> Levels Horizontal

Hi,

In my report I have a level of Year on one formula.

At the moment it's like this in my word template :

level.PNG

The result is :

level 1.PNG

I would like something horizontal like below without create 3 formulas :

level 2.png

How can I do that ?

Regards,

Kevin

12 Replies
woutermak
Partner - Creator III
Partner - Creator III

Hi,

Is it necessary to use levels?

Can’t you create three text boxes with a the last three years and the values in it?

The level will create a new detail section per year. So you need to show all the data in the same level, or don’t use a level

kevinchevrier
Partner - Creator III
Partner - Creator III
Author

Hi,

Is it necessary to use levels?

It would be better for me and performance of the report. Because, here it's just an example.

I have 5 indicators like that. So it means 5 * 3 = 15 formulas...

"The level will create a new detail section per year." ==> Yes, I know. But could this section be horizontal instead of vertical ?

Kevin

Daniel_Jenkins
Specialist III
Specialist III

Hi Kevin,

Why not use PixelPerfect?

Say you have a table like this:

You can set up a multi-column report like this:

To get a report like this:

HTH - Daniel.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

djk Daniel - you are a champion with your tips and tricks!

Do you have any source / book / materials on how to do things in Pixel Perfect? I know Pixel Perfect properties look similar to other "report builders". What would be the best one to look at in order to learn Pixel Perfect?

It apeared to me so many times that posibilities with PPX are endless and you just need to know that they are there!

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
kevinchevrier
Partner - Creator III
Partner - Creator III
Author

Hi Daniel,

For sure it seems to be better but I spent lot of time for my report on word.

I can't change now...

Kevin

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

how about building straight table in Qlik:

  • dimension: ='Sales for '&Year
  • expresion: sum(Sales)

Table:

1.png

Load this table to your word template:

1.png

  • create a word table from this
  • disable "keep source formatting"
  • add a textbox to your word document and put your table inside of it
  • change the text direction in your word table:

1.png

at the end rotate whole textbox together with your table inside

1.png

adjust table formatting according to your needs and voila

1.png

it is little bit of playing around - but at the end it is actualy what you need (without level in your template and without expression modification)

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
kevinchevrier
Partner - Creator III
Partner - Creator III
Author

Hi Lech,

and voila ==> It make me laugh

Thank you for your answer but we don't want to change it in our Qlikview App. We also don't want to create new table (in an hidden sheet) just for NPrinting. If we do that for one, we will do it for others. Then, the maintenance will be more difficult.

Kevin

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Whatever suits you mate!

yeah - "voila" was sarcastic as whole thing wa actualy quite painful to do!

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
kevinchevrier
Partner - Creator III
Partner - Creator III
Author

Hi,

I finally decide to do it with 3 formulas for each....

But I have to do it also for one indicator with pictures. Any kind of solution on word template ?


Thank you


Kevin