2 Replies Latest reply: Mar 18, 2015 4:04 AM by Manish Kachhia RSS

    How to create a calendar.

    Jim Chan

      Hi all, i think i have posted a calendar related issue.

       

      I need a Calendar selection where when i click on February,

       

      in Graph 1 - it shows the sum of(bill_tech+bill_func) , date based on logged_date

       

      in Graph 2 - it show the sum of(bill_tech+bill_func) , use date based on closed_date WHERE desc = 'closed'

       

       

      logged_date

      closed_datedescbill_techbill_func

      01/012015

      13/01/2015closed1312
      02/02/201514/02/2015closed32
      13/03/201516/03/2015in progress210
      15/04/201517/04/2015open

      6

      8

       

      So, how can achieve that by using oni 1 Month selection.?

       

      i have tried using master calendar concept, and the expression that i wrote is month([Close Date],[Sta_Desc]= 'Closed')

        • Re: How to create a calendar.
          Colin Albert

          Have a look at this post by hic which has the solution http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

           

          You will need to create Date Types for Logged Date & Closed Date in the bridge table.

          • Re: How to create a calendar.
            Manish Kachhia

            Use below Script

            ===============================================

            Main:

            Load * Inline

            [

              logged_date, closed_date, desc, bill_tech, bill_func

              01/01/2015,   13/01/2015, closed, 13, 12

              02/02/2015, 14/02/2015, closed, 3, 2

              13/03/2015, 16/03/2015, in progress, 2, 10

              15/04/2015, 17/04/2015, open, 6, 8

            ];

             

             

            Final:

            Load

              logged_date as Date,

              'LoggedDate' as Flag,

              desc,

              bill_tech,

              bill_func

            Resident Main;

            Concatenate

            Load

              closed_date as Date,

              'ClosedDate' as Flag,

              desc,

              bill_tech,

              bill_func

            Resident Main;

             

             

            Left Join (Final)

            Load Date, Month(Date) as Month Resident Final;

             

            Drop Table Main;

             

            =================================

             

            Now create a Straight Table or Bar/Line Chart

            Dimension

            Date

            Expression

            SUM({<Flag = {'LoggedDate'}>}bill_tech) + SUM({<Flag = {'LoggedDate'}>}bill_func)

             

            Another Table/Chart

            Dimension

            Date

            Expression

            SUM({<Flag = {'ClosedDate'}, desc = {'closed'}>}bill_tech) + SUM({<Flag = {'ClosedDate'}, desc = {'closed'}>}bill_func)