Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Refresh

I have a variable into a text box which gives me a number of pages forselected ID

for example 1 of 4 etc.when i select 4 then it shows me the data of 4 of 4 but when i go back to main page and select different id then come to the

same pages it wont refresh , still it will be displaying the 4 of 4. i have to change every time by selecting .

what do i need to do to refresh this variable ?

this is the variable i am using

Page '& vPagecount & ' of ' & vPageCounttotal

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

How are the two underlying variables (vPagecount, vPageCounttotal) defined?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

I really dont understand what you are trying to do here. How do you expect a constant value (vPageCount) to change? And I cannot unravel your expression for vPageCounttotal.

What are you trying to calculate? If you want help you need to provide full details of ALL variables used - how is vRowsLDE defined? Are StartDate and EndDate variables? Does the expression work if you use it in a textbox? If not, have you broken it into parts to determine which part is working and which is not working? Did you define vPageCounttotal with a leading = sign?

I suggest that you upload a small sample qvw with some representative data and all the variables defined for more detailed help.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
smilingjohn
Specialist
Specialist
Author

Yes it works ,

the second variable  vPageCounttotal    displays the number of pages .

where as the first variable vpagecount1  is just a number , i need to clear the first variable to set back to 1 always