topic Re: pls help in adding column on variable event trigger(slider) in QlikView

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

Tue, 09 Jul 2013 18:41:43 GMT

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

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

stephencredmond — Tue, 09 Jul 2013 19:29:14 GMT

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

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

Wed, 10 Jul 2013 05:13:45 GMT

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

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

stephencredmond — Wed, 10 Jul 2013 08:27:00 GMT

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

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

Thu, 11 Jul 2013 06:01:14 GMT

thanks a tonne ...:)

it worked and was of great help to me ..

so kind of you ...u made my day