8 Replies Latest reply: Mar 12, 2015 6:05 AM by naidu k RSS

    Fixed Column Analysis

      Hi,

       

      I've got a problem which is easy to solve in Excel but is proving intractable in QlikView. I have a chart as such:

       

           2015-01-13                                   2015-02-12                                   2015-03-11

      A          B          C                         A          B          C                            A          B          C

      9          2           2.25                     8          7          2                            12          4          3

      7          3           1.16                     6          4          1                            15          6          2.5

      8          4            1.6                      7          5         1.4                          14          5          2.8

       

      Now, consider the following:

       

      1. Column C (Green) is a calculated column. C = A/B
      2. Also notice that Column C is calculated using Column A (Blue) in each set but only Column B (Red) from the last set
        (2015-03-11). This is why the Column Bs in the first two sets (2015-01-13 & 2015-02-12) are left gray.

       

      How can I do this in QlikView? In Excel it's a simple task of "locking" one column and dynamically calculating from the others. In QlikView this does not seem possible.

       

      Any help is much appreciated.

       

      -Abhijeet.