topic Re: Refresh in QlikView

Refresh

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Refresh

jonathandienst — Tue, 27 Sep 2016 05:19:52 GMT

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

Re: Refresh

jonathandienst — Tue, 27 Sep 2016 05:51:24 GMT

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.

Re: Refresh

smilingjohn — Tue, 27 Sep 2016 06:51:45 GMT

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