topic Re: EmpId Increment in QlikView

EmpId Increment

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Have a nice day.

When i click the NEXT button the EmpId will increment by +1 (302)

When i click the PREVIOUS button the EmpId will decrement by -1 (300)

Is it possible? if yes , Please Gide me.

Re: EmpId Increment

sunny_talwar — Thu, 09 Jun 2016 12:02:56 GMT

May be you can derive insights from here:

Paging Implementation for Straight table

Re: EmpId Increment

avinashelite — Thu, 09 Jun 2016 12:06:21 GMT

Yes, Its possible . Try like this add action in both the buttons

Add action>Select in Field

Field name : [Emp Id]

Expression: getfieldselection([Emp Id])-1

Add action>Select in Field

Field name : [Emp Id]

Expression: getfieldselection([Emp Id])+1

Re: EmpId Increment

Digvijay_Singh — Thu, 09 Jun 2016 12:12:01 GMT

One click is required for both clicking button or clicking the value directly, any specific reason you need this functionality on a lighter note, may be client is forcing to match new BI application with legacy application.

Re: EmpId Increment

susovan — Thu, 09 Jun 2016 12:47:18 GMT

Try this attachment,

Re: EmpId Increment

Thu, 09 Jun 2016 12:57:05 GMT

Thank for quick reply.

But i am using desktop version , i have no license

Re: EmpId Increment

Thu, 09 Jun 2016 13:02:16 GMT

Hi Susovan Ghosh ,

Thank you for reply ,Could you please provide Expressions. i am using desktop version(No license),

Re: EmpId Increment

Thu, 09 Jun 2016 13:08:23 GMT

Thank you Avinash .

Its working.

Re: EmpId Increment

susovan — Fri, 10 Jun 2016 07:12:10 GMT

Hi Ramu,

Try this following expression

For Next button : =if(Filed='300' or Filed<'350',Filed+1,'300')

For Previous button : set this (Back) trigger