Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Straight Table loading logic

Hi All,

             i have a requirement of displaying a straight table of 7 columns in which 2 column values are dynamically changed based on one input box.

           I set formulas for these 2 columns as Col1 * (Col1 * inputboxval / 100). this formula is working fine if i do this operation for all rows.

         i have material filter if i select one material and enter any value in input box this formula executed and table columns are updated. But if i remove this material filtration selection(With intention to show all materials), updated value in input box is applies to all (material) rows. (Please check the attached file)

        So i decided to put one Apply button. and want to execute some VBScript to do this functionality.

        My problem here is how can i bind data to straight table dynamically using VBScript ..?

   

Regards,

Praveen

5 Replies

Re: Straight Table loading logic

Hi,

     Do you mean to say that after selecting one product and the value of the input box should remain same for that even after deselection?

Regards,

Kaushik Solanki

Not applicable

Re: Straight Table loading logic

Kaushik,

           First i applied value 20 to all materials using input box (00.16 sec in video).

           Then i want to apply 10 to material  MAT-001 so i selected mat-001 and entered 10 in input box

           Now i want to see all materials so i cleared filter. This time inputbox value 10 is applied to all materials. i Don't want this 10 to all materials now. i planned to put one button apply. but i couldn't find a way to set table cell value using macro also. So i decided to handle this functionality in load logic. is it possible ?

Regards,

Praveen

Re: Straight Table loading logic

Hi,

     There is no way, you can use the variable to do this.

     You can use the concept of Input Field or you can define the values in script for each of the product, but then that will be a static value, which cant be changed as per user from front end.

Regards,

Kaushik Solanki

Not applicable

Re: Straight Table loading logic

Kaushik,

       I want only dynamic way. I want to enter this value during runt time(not statically). So

         - If i remove this formula for result column then using apply button i will execute one macro then i'll calculate result value. now is it possible to set this result to particular cell ?

Regards,

Praveen

Re: Straight Table loading logic

Hi,

     I dont think so its possible.

Regards,

Kaushik Solanki