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: 
Not applicable

[Page] and [Pages] in expression

Hi,

into my report I need to insert information about page number and total number of pages. As the report is looped by dimension, the page and pages information needs to be put as an expression. Any idea what the expression should be like?

Regards,

Przemek

1 Solution

Accepted Solutions
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hello Przemysław Wojda

See the attached image ..

sample.bmp

1) Create a new variable, in this example vPage

2) Assign the expression to this variable

3) Use the var on the repport settings dialog

My goal was write the expression marked on green, the explantion of the expression is.

a) FieldValue(Idioma, 313) for the text 'Page' on the user language

b) chr(38) & chr(91) & 'Page' & chr(93) to add &[Page] function

c) FieldValue(Idioma, 314) for the text 'of' on the user language

d) chr(38) & chr(91) & 'Pages' & chr(93)  to add &[Pages] function

Your goal if complete the vPage with your own expression. Good luck

View solution in original post

3 Replies
Gysbert_Wassenaar

If you want to reset the page count on every change of dimension value, then I think you're out of luck. If all you want is to add the page number and the total number of pages then you can use the standard buttons (first two on the left) on the Header/Footer tab of the Report Settings screen.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you, Gysbert. Any idea how to put the count into expression?

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hello Przemysław Wojda

See the attached image ..

sample.bmp

1) Create a new variable, in this example vPage

2) Assign the expression to this variable

3) Use the var on the repport settings dialog

My goal was write the expression marked on green, the explantion of the expression is.

a) FieldValue(Idioma, 313) for the text 'Page' on the user language

b) chr(38) & chr(91) & 'Page' & chr(93) to add &[Page] function

c) FieldValue(Idioma, 314) for the text 'of' on the user language

d) chr(38) & chr(91) & 'Pages' & chr(93)  to add &[Pages] function

Your goal if complete the vPage with your own expression. Good luck