4 Replies Latest reply: May 22, 2017 7:12 AM by munirathnam p RSS

    Issue with Line chart label

    munirathnam p

      Hi All,

       

      i have a line chart and i have applied color by measure.

      The problem is i am seeing the condition as label and two labels are displaying.

       

      How to restrict it to display a single label instead of the actual condition.

       

      PFA screen shot.

       

       

      Thanks,

      Rathnam.

        • Re: Issue with Line chart label
          Ashwin Lakshmanan

          Hi Rathnam,

           

          Did you try going to Data --> Measures and add a value to the "label"? Whatever you enter here will be displayed instead of the actual formula.

           

           

           

          Happy Qlik-ing!

            • Re: Issue with Line chart label
              munirathnam p

              Hi Ashwin,

               

              Thanks for your reply.

               

              i have given label name to measure.You can see "Sales" label. The formula is displaying because after applying color by measure.

               

               

              Thanks,

              Muni.

                • Re: Issue with Line chart label
                  Ashwin Lakshmanan

                  Can you show me your dimension, measure and color values?

                   

                   

                  Thanks

                    • Re: Issue with Line chart label
                      munirathnam p

                      Hi Ashwin,

                       

                      sorry for late response.

                       

                      PFB


                      Dimension:

                       

                      IF(daystart(time_period_date) - daystart(NOW()) < 0  ,'(A)Past Due'

                        ,IF(daystart(time_period_date) - daystart(NOW()) >= 0 AND relative_global_quarter = 0 ,fiscal_month_mmm

                        ,IF(daystart(time_period_date) - daystart(NOW()) >= 0 AND relative_global_quarter = 1 ,fiscal_quarter_desc

                        ,IF(daystart(time_period_date) - daystart(NOW()) >= 0 AND relative_global_quarter = 2 ,fiscal_quarter_desc

                      ))))

                       

                      Measure:

                      IF(GetFieldSelections(View_Currency)='USD',

                      IF(GetFieldSelections(category)='CRD'

                        ,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,crd_nsb)),'$#,##0;($#,##0)')

                        ,IF(GetFieldSelections(category)='OPD'

                           ,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,opd_nsb)),'$#,##0;($#,##0)')

                           ,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,ssd_nsb)),'$#,##0;($#,##0)')

                           )

                        ),

                      IF(GetFieldSelections(View_Currency)='EUR',

                      IF(GetFieldSelections(category)='CRD'

                        ,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,crd_nsb_eur)),'€#,##0;(€#,##0)')

                        ,IF(GetFieldSelections(category)='OPD'

                           ,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,opd_nsb_eur)),'€#,##0;(€#,##0)')

                           ,Num(sum(IF(classification ='OPERATIONAL' AND relative_global_quarter >=0 AND relative_global_quarter <=2,ssd_nsb_eur)),'€#,##0;(€#,##0)')

                           )

                        )

                      ))

                       

                      Color: i am applying by measure.

                       

                       

                      Thanks