6 Replies Latest reply: Aug 16, 2011 8:12 AM by williamcalsolari RSS

    You can add lines to the QlikView ?

      If someone can help me, I created the following script:

            IF(NUM(ACCOUNT) = 31102140001, 'REVENUE 01',
            IF(NUM(ACCOUNT) = 31102140002, 'REVENUE 02',
            IF(NUM(ACCOUNT) = 31102180001, 'EXPENSES',
            IF(NUM(ACCOUNT) = 31102190002, 'TAXES', )))) AS DRE,


      each item that shows me in a row when I create a dynamic table in QlikView and sum total of them in the last line, I wonder if I can insert a row to make the sum of 01 and INCOME 02 REVENUES TOTAL REVENUES which would be called if can please help me.

      Thank you,

      William