11 Replies Latest reply: Apr 13, 2012 10:32 AM by Matthias Steiling RSS

COPA formula in rows

Schneyinck

Hi

the Cost of Sales scheme is one example for a report which has formula logic in the robw

e.g.

 

row A: gross sales

row B: Sales deduction

row C: net sales (means row A - row B)

row D: % deduction (means 100*row B/row A)

 

Does anyone have an idea how to get a formula logic into the rows. Other formula rules (like deviation plan vs actuals of the cost scheme) shall stay in the columns.

 

best regards

Eckhard

  • COPA formula in rows
    Juan Olivares

    I think your are trying to create a statement right? If so, try to see a example in the qlikview web page, it probably gives you a great idea of how to do it.

    • COPA formula in rows
      Schneyinck

      Hi Jolivares,

      thanks for your reply. Could you explicitly name the example on the qv page please

      rgds Eckhard

        • Re: COPA formula in rows
          Schneyinck

          Hi Jolivares

           

          I know that link. Checkin some examples I did not find a chart with expressions in rows AND columns.

          Rgds Eckhard

          • COPA formula in rows
            Juan Olivares

            Ok... one way to build statement is create a field "item", for example, where you put all the descripcions and another field you put "values".  In this case you have to calculate in your script the values for that column.  Once you have that table created you may display the results.

             

            Remember that statements are customizable, each case is different, so you have to buil "manually"

            • Re: COPA formula in rows
              Schneyinck

              Hi I will try that.

               

              This is the first time I face a real problem with Qlikview …

              Thanks eckhard

              • Re: COPA formula in rows
                Rakesh Mehta

                Hi Eckhard,

                 

                Hope you are doing well and enjoying QlikView Developments.

                I think enclosed is what you are looking for. Please let me know if you need any further help.

                 

                Rakesh

                • Re: COPA formula in rows
                  Schneyinck

                  Hi Rakesh,

                  thanks for your help, I will check it in a few minutes. I guess you know what is going on here ;-) Qlikview development is great for SAP data. I am impressed: I have developed and loaded a table like AUFK within 15 MINUTES!!!

                  My main focus is in Cost Accounting COEP and all around.

                  Hope you are doing well.

                  rgds

                  Eckhard

                  • Re: COPA formula in rows
                    Matthias Steiling

                    Ich bin bis 16.04.2012 abwesend

                     

                    Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.

                    Bei einer kurzfristigen Lösung bitte ich Sie die Mail an Herrn Pohlschmidt

                    (-139) weiterzuleiten oder Ihn telefonisch zu kontaktieren.

                     

                     

                    Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht  "[SAP] -

                    Re: COPA formula in rows" gesendet am 13.04.2012 11:47:10.

                     

                    Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während

                    diese Person abwesend ist.

                • Re: COPA formula in rows
                  Schneyinck

                  Hi Rakesh,

                  thanks for your help, I will check it in a few minutes. I guess you know what is going on here ;-) Qlikview development is great for SAP data. I am impressed: I have developed and loaded a table like AUFK within 15 MINUTES!!!

                  My main focus is in Cost Accounting COEP and all around.

                  Hope you are doing well.

                  rgds

                  Eckhard

                  • Re: COPA formula in rows
                    Matthias Steiling

                    Ich bin bis 16.04.2012 abwesend

                     

                    Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.

                    Bei einer kurzfristigen Lösung bitte ich Sie die Mail an Herrn Pohlschmidt

                    (-139) weiterzuleiten oder Ihn telefonisch zu kontaktieren.

                     

                     

                    Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht  "[SAP] -

                    Re: COPA formula in rows" gesendet am 13.04.2012 11:48:05.

                     

                    Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während

                    diese Person abwesend ist.