5 Replies Latest reply: Nov 28, 2017 12:11 AM by Manojkumar Basa RSS

    Count of multiple field

    Manojkumar Basa

      Hi friends

       

      I am facing a one problem please help me..

       

      There are 400 leads in that leads only few leads will go to boarding... based on boarding time we should count.. can any one give me set analysis expression for that..

       

      I want to count that leads which are going to boarding...

        • Re: Count of multiple field
          omar bensalem

          do you have a field in your script for the bording?

          I mean sthung like a state field that contains values : borading and not boarding?

           

          if so:

          count({<state={'boarding'}>}leads)

            • Re: Count of multiple field
              Manojkumar Basa

              Thank you for your reply..

              In my script I am not using a master calendar script.. Based on field name(Created Date) I am getting a result..

              My table is showing from 2017 jan 1st - till 23rd Nov 2017.

               

              My Question:- Whenever I am opening an app, It must be show with Current month details:

                It is in Qliksense not in Qlikveiw

              Where should i use month function, Can you please do correction in my expression:

              Below is my script:

              Count({$<assign_to_city={'Mumbai','Bangalore','Delhi','Jaipur','Ahmedabad','Pune','Cochin','Kolkata','Mohali','Lucknow','Indore','Hyderabad','Chennai'},campaign_no={'CAM31'}>}leadid)

                • Re: Count of multiple field
                  Shraddha Gajare

                  What should be the condition for 'Boarding'? how it should get calculated from Created Date?

                    • Re: Count of multiple field
                      Manojkumar Basa

                      Based on created date we can calculate, every month how many leads are receiving..

                      Load

                      id as leadid,

                      createdDate,

                      Month(createddate) as Month,

                      Year(createddate) as Year,

                      from T_CRMEntity.QVD;

                       

                      Above is my script

                      I have taken One filter Month and Year  and I choose one Table their i have taken dimension as city name and measure as below script:

                      Count({$<assign_to_city={'Mumbai','Bangalore','Delhi','Jaipur','Ahmedabad','Pune','Cochin','Kolkata','Mohali','Lucknow','Indore','Hyderabad','Chennai'},campaign_no={'CAM31'}>}leadid)

                       

                      In Qliksense When ever the app opening it must be open with current month..

                       

                      Please give the correct expression..

                       

                      For your question answer is I have a filed called Boarding time based on that we can calculate...

                • Re: Count of multiple field
                  Shraddha Gajare

                  In Load Script you can create a field for Boarding Status.

                  For Example,  if(isnull([Boarding Date]),0,1) as BoardingStatus

                   

                  In Expression,

                   

                  Count(Distinct {<BoardingStatus = {'1'}>} Leads)