pls help in adding column on variable event trigger(slider)

[#1]

Hello All,

Can nyone pls help me in determining how the column wih calculated value from slider ( what if analsis)

will be added or reflected on slider movement itself ???

i have simple column A , B , C ...

A-QUARTER

B-MONTH

C-LOCAL CALLS

I want D Column with increased value through variable of slider to be added ...to above table

I have no knowledge of Java Script

plsss help

[stephencredmond]

Hi,

I usually add a slider attached to a variable (e.g. vCallWhatIf) and set the range for the slider to something like -0.3 to 0.3 with a static step of 0.01.

Then, in your column D, you would have a calculation like:

   Sum(Calls) * (1+vCallWhatIf)

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond

[#3]

thank you stephon

but my requirement is that column D should only appear when i move the slider from 0 position

else only column A , B AND C should be visble ...

Please help me in this regard

[stephencredmond]

Hi,

That is very easy.  Just put a Conditional expression on column D that vCallWhatIf <> 0.

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond

[#5]

thanks a tonne ...:)

it worked and was of great help to me ..

so kind of you ...u made my day