5 Replies Latest reply: Mar 10, 2016 3:52 AM by bruno bertels RSS

    Weekly due date in table

    mrdee onno

      Hi Master QS,

       

      I have problem to make a report in table format like this :

       

      Report.PNG

      The data i have is in column A-D

       

      Can i make Due Date then W1 - Wn in Qlik Sense? !

        • Re: Weekly due date in table
          bruno bertels

          Hi

           

          Does something like this respond to your requierment ?

           

          • Re: Weekly due date in table
            mrdee onno

            Hai Bruno,

             

            Thanks for ur respons,

             

            Can 1 get summary above in table not pivot table  because i still export it to Excell, pivot table can't export to Excell file.

             

            Note : Amount / week get from due date.

              • Re: Weekly due date in table
                bruno bertels

                 

                Hi

                 

                Like that ?

                :

                 

                see attached app last sheet

                  • Re: Weekly due date in table
                    mrdee onno

                    Thanks allot bruno bertels,

                     

                    it helpfull, so i still must add expression manual to make W1,W2 - Wn ? can i make automaticly?

                      • Re: Weekly due date in table
                        bruno bertels

                        Hi

                         

                        Not sure to understand what you mean by " make automaticly".

                         

                        First way consisted in adding mesure sum(amount) with an If statement and named each mesure as W1, W2 etc

                         

                        second approach with calculated dimension :

                         

                        add this to your script :

                         

                        LOAD

                            Name,

                            AMOUNT,

                            "Invoice Date",

                            "Lead Time (Days)",

                          

                            if(

                        week([Invoice Date]+[Lead Time (Days)])=2,AMOUNT,0) as "W2",

                            if(

                        week([Invoice Date]+[Lead Time (Days)])=3,AMOUNT,0) as "W3",

                            if(

                        week([Invoice Date]+[Lead Time (Days)])=4,AMOUNT,0) as "W4",

                            if(

                        week([Invoice Date]+[Lead Time (Days)])=5,AMOUNT,0) as "W5",

                            if(

                        week([Invoice Date]+[Lead Time (Days)])=6,AMOUNT,0) as "W6",

                            if(

                        week([Invoice Date]+[Lead Time (Days)])=7,AMOUNT,0) as "W7",

                            if(

                        week([Invoice Date]+[Lead Time (Days)])>=8,AMOUNT,0) as "W>=8"

                         

                        from ....

                         

                        this time it will add several dimension W1, W2 etc

                        just drag and drop those dimensions in your table.

                        You may have this :

                         

                         

                        note that by this way Totals line not available

                         

                        bruno