Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

upaliwije
Contributor 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
MVP & Luminary
MVP & Luminary

Re: Print a Text Object

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
Contributor II

Re: Print a Text Object

Dear Friends, Pls help me with some solution
Partner
Partner

Re: Print a Text Object

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
Contributor II

Re: Print a Text Object

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 .

 

Partner
Partner

Re: Print a Text Object

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

Or are you looking for ways to generate PDF report?

upaliwije
Contributor II

Re: Print a Text Object

Yes PDF  Report

Digital Support
Digital Support

Re: Print a Text Object

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
MVP & Luminary
MVP & Luminary

Re: Print a Text Object

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