Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Print a Text Object

Hi Friends

In my QV document I have loaded data relating to vehicle parts and it is displayed in a table box as  shown below. Screenshot_4.png

I want the records in Table box to be printed as labels  (to be affixed on the part)  as shown above. I think this has to be arranged a text box and then print. However I am not aware  of how to do it. I seek your help to fulfill my requirement please. 

 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

1. Make a Straight Table chart with a calculated dimension like:

=PART_NO
& chr(10) & MAKE
& chr(10) & MODEL

2. On the Presentation tab, set the Cell Height to the number of lines per label. 

3. Use the Style tab to remove all the separator lines. 

4. Add the chart to a QV Report and print it.  See the "Invoice" sheet in this example for an example of formatting and printing a report. 

Qlikview Cookbook: Conditional Show of Details http://qlikviewcookbook.com/recipes/download-info/conditional-show-of-details/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

7 Replies
upaliwije
Creator II
Creator II
Author

Dear Friends, Pls help me with some solution
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

In load script, add in a rowno() for ranking purpose, example:

 

Raw:
load * inline [
Field1,Field2,Field3
1,A,A1
2,A,A1
3,A,A2
4,B,B1
5,B,B1
6,C,C1
];
Data:
load *, if(RowNo()=1,1,if(peek(Field2)=Field2 and peek(Field3)=Field3,0,2)) as Rank2
Resident Raw;
drop table Raw;
NoConcatenate
TempData:
load * ,if(RowNo()=1,1,peek(Rank)+1) as Rank
Resident Data
where Rank2 <>0;
drop table Data;

EXIT Script;

 

Then at front end, insert a textbox and try this:

 

='Field1: '&only({<Rank={1}>}Field1)& chr(10)&'Field2: '&only({<Rank={1}>}Field2)& chr(10)&'Field3: '&only({<Rank={1}>}Field3)&chr(10)

You should get:

MC.PNG

Insert a new textbox Replace Rank =1 to Rank =2 to get the second textbox:

='Field1: '&only({<Rank={2}>}Field1)& chr(10)&'Field2: '&only({<Rank={2}>}Field2)& chr(10)&'Field3: '&only({<Rank={2}>}Field3)&chr(10)

 

Continue with Rank =3 and Rank =4 and you will get:

MC2.PNG

 

upaliwije
Creator II
Creator II
Author

Thanks  Arthur,

It works fine. But my concern is when there are thousands of records have I got to create text objects for each rank. That is not  practical. I am  looking for some thing where once done all labels should appear one after the other to print. Kindly help me with that .

 

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

How could you fit 1000 of text object in a dashboard?

Or are you looking for ways to generate PDF report?

upaliwije
Creator II
Creator II
Author

Yes PDF  Report

Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post as well, might be another way to go in this use case:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

1. Make a Straight Table chart with a calculated dimension like:

=PART_NO
& chr(10) & MAKE
& chr(10) & MODEL

2. On the Presentation tab, set the Cell Height to the number of lines per label. 

3. Use the Style tab to remove all the separator lines. 

4. Add the chart to a QV Report and print it.  See the "Invoice" sheet in this example for an example of formatting and printing a report. 

Qlikview Cookbook: Conditional Show of Details http://qlikviewcookbook.com/recipes/download-info/conditional-show-of-details/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com